SELECT t.range AS [0-1], count(Employee_ID) AS [Number of Employees]
FROM (
SELECT CASE
WHEN score BETWEEN 0 AND 0.25 THEN ‘0-0.25’
WHEN score BETWEEN 0.25 AND 0.5 THEN ‘0.25-0.5’
WHEN score BETWEEN 0.5 AND 0.75 THEN ‘0.5-0.75’
WHEN score BETWEEN 0.75 AND 1 THEN ‘0.75-1’
FROM Evaluation)
GROUP BY t.range;