Show All Games with Duration and Part of the Day

SELECT [Name] AS 'Game',
    CASE
        WHEN DATEPART(HOUR, [START]) BETWEEN 0 AND 11 THEN 'Morning'
        WHEN DATEPART(HOUR, [START]) BETWEEN 12 AND 17 THEN 'Afternoon'
        ELSE 'Evening'
    END AS 'Part of the Day',
    CASE
        WHEN Duration <= 3 THEN 'Extra Short'
        WHEN Duration BETWEEN 4 AND 6 THEN 'Short'
        WHEN Duration > 6 THEN 'Long'
        ELSE 'Extra Long'
    END AS 'Duration'
FROM GAMES
    ORDER BY [Name], Duration