Untitled

SELECT id,
       views,
       CASE 
           WHEN views >= 350 THEN 1
           WHEN 100 <= views AND views < 350 THEN 2
           ELSE 3
        END
FROM stackoverflow.users
WHERE location = 'United States' AND
      views != 0