Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
243 B
2
Indexable
Never
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