Hi Glass -but then how do I eliminate double couting 1.0 or 2.0, as it would qualify for both categories. The values are floating decimals so I need to ensure the correct values are falling into correct categories without leaving any out, or double couting. "between 1.0001 and 2.0" then "between 2.0001 and 3.0"? Was hoping for something a little cleaner and precise than that. Any ideas?
Simply don't use BETWEEN, replace it with >= and < instead:
SUM (CASE WHEN d.DCG >=0.50 and d.DCG <1.0 THEN 1 ELSE 0 END) AS "0.5-1.0",