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
