Untitled

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