Grouping Data Into Ranges

[sainandoor]

I am trying to get the count for date in different ranges. I used the following query:
SELECT SUM(CASE WHEN CoilLength < 50 then 1 else 0 END CASE) as '50', SUM (CASE WHEN CoilLength between 50 and 100 then 1 else 0 END CASE) as '50to100',
SUM (CASE WHEN CoilLength > 100 then 1 else 0 END CASE) as '100' from tblCoiledCoil;

I get a generic syntax error. If I use END instead of END CASE I get an error saying function myDB.SUM doesn't exist. Any ideas on how to fix it?