Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment
SELECT (CASE WHEN LOWER(Location) LIKE '%argentina%' THEN 'Argentina' WHEN LOWER(Location) LIKE '%armenia%' THEN 'Armenia' WHEN LOWER(Location) LIKE '%australia%' THEN 'Australia' WHEN LOWER(Location) LIKE '%austria%' THEN 'Austria' WHEN LOWER(Location) LIKE '%bangladesh%' THEN 'Bangladesh' WHEN LOWER(Location) LIKE '%belarus%' THEN 'Belarus' WHEN LOWER(Location) LIKE '%belgium%' THEN 'Belgium' WHEN LOWER(Location) LIKE '%brazil%' THEN 'Brazil' END) as country, COUNT(Id) FROM Users WHERE Reputation >= 1000 GROUP by (CASE WHEN LOWER(Location) LIKE '%argentina%' THEN 'Argentina' WHEN LOWER(Location) LIKE '%armenia%' THEN 'Armenia' WHEN LOWER(Location) LIKE '%australia%' THEN 'Australia' WHEN LOWER(Location) LIKE '%austria%' THEN 'Austria' WHEN LOWER(Location) LIKE '%bangladesh%' THEN 'Bangladesh' WHEN LOWER(Location) LIKE '%belarus%' THEN 'Belarus' WHEN LOWER(Location) LIKE '%belgium%' THEN 'Belgium' WHEN LOWER(Location) LIKE '%brazil%' THEN 'Brazil' END)