Get last 6 months name in SQL code example

Example: sql where last 12 months

select Dateadd(Month, -12, GETDATE())