Q&A about the site for serious players and enthusiasts of poker
--- Which provinces are the users from?
-- Based on their filled in location
WITH UsersProvince AS (
WHEN UPPER(Location) LIKE '%VANCOUVER, B%' THEN 'BC - Vancouver'
WHEN UPPER(Location) LIKE '%CANADA%' THEN 'Canada'
ELSE 'Z - Not Canada or Unknown'
END AS Province
WHERE LEN(Location) > 2
GROUP BY UsersProvince.Province
-- ORDER BY count(1) desc
ORDER BY Province asc