[Exercise Data Aggregation] - Problem 09. Age Groups
SELECT
CASE
WHEN w.Age BETWEEN 0 AND 10 THEN '[0-10]'
WHEN w.Age BETWEEN 11 AND 20 THEN '[11-20]'
WHEN w.Age BETWEEN 21 AND 30 THEN '[21-30]'
WHEN w.Age BETWEEN 31 AND 40 THEN '[31-40]'
WHEN w.Age BETWEEN 41 AND 50 THEN '[41-50]'
WHEN w.Age BETWEEN 51 AND 60 THEN '[51-60]'
WHEN w.Age >= 61 THEN '[60+]'
END AS [AgeGroup],
COUNT(*) AS [WizardCount]
FROM WizzardDeposits AS w
GROUP BY CASE
WHEN w.Age BETWEEN 0 AND 10 THEN '[0-10]'
WHEN w.Age BETWEEN 11 AND 20 THEN '[11-20]'
WHEN w.Age BETWEEN 21 AND 30 THEN '[21-30]'
WHEN w.Age BETWEEN 31 AND 40 THEN '[31-40]'
WHEN w.Age BETWEEN 41 AND 50 THEN '[41-50]'
WHEN w.Age BETWEEN 51 AND 60 THEN '[51-60]'
WHEN w.Age >= 61 THEN '[60+]'
END
Получавам верен резултат според примера, който е посочен в домашното, но Judge не смята така? Не мога да открия какъв е проблема и ще се радвам някой да удари едно рамо по въпроса.
https://github.com/melikpehlivanov/Databases-Basics---MS-SQL-Server---2017/blob/master/Data%20Aggregation/Data%20Aggregation%2C%20All%20problems.sql