how to write a query to get following result

SELECT SAL,
CASE
  WHEN SAL >= 1000 THEN '*'
  WHEN SAL >= 2000 and SAL <3000 THEN '**'
  WHEN SAL >= 3000 and SAL <4000 THEN '***'
  WHEN SAL >= 4000 and SAL <5000 THEN '****'
  WHEN SAL >= 5000 and SAL <6000 THEN '*****'
  ELSE ''
END AS [RANK]
FROM [TableName];