random jottings

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

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 (
SELECT 
          CASE                
                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
FROM Users
      WHERE LEN(Location) > 2
)

SELECT UsersProvince.Province
      FROM UsersProvince

GROUP BY UsersProvince.Province
-- ORDER BY count(1) desc
ORDER BY Province asc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results