SELECT [Name] AS [Game]
     , CASE
            WHEN DATEPART(hour,[Start]) >= 0 AND DATEPART(hour,[Start]) < 12 THEN 'Morning'
            WHEN DATEPART(hour, [Start]) >= 12 AND DATEPART(hour,[Start]) < 18 THEN 'Afternoon'
            WHEN DATEPART(hour, [Start]) >= 18 AND DATEPART(hour,[Start]) < 24 THEN 'Evening'
       END AS 'Part of the Day'
     , Case
            WHEN [Duration] <= 3 THEN 'Extra Short'
            WHEN [Duration] >= 4 AND [Duration] <= 6 THEN 'Short'
            WHEN [Duration] > 6 THEN 'Long'
            ELSE 'Extra Long'
       END AS 'Duration'

  FROM Games
ORDER BY [Name],
         [Duration],
         [Start]