USE WorldEvents

​

SELECT * FROM(SELECT CountryName,

CASE

WHEN ContinentID = 1 OR ContinentID = 3 THEN 'Eurasia'

WHEN ContinentID = 6 OR ContinentID = 5 THEN 'Americas'

WHEN ContinentID = 2 OR ContinentID = 4 THEN 'Somewhere hot'

WHEN ContinentID = 7 THEN 'Somewhere cold'

ELSE 'Somewhere else'

END AS 'CountryLocation'

​

FROM tblCountry) AS t

​

ORDER By CountryLocation DESC