Untitled

mail@pastecode.io avatarunknown
plain_text
2 months ago
203 B
3
Indexable
Never
SELECT id,
views,
CASE
   WHEN views >=350 then 1
   WHEN views >=100 and views <350 then 2
   WHEN views <100 then 3
END
FROM stackoverflow.users as u 
WHERE location LIKE 'Canada'  and views!=0