- SELECT id,
- cs,
- MAX (views) OVER (PARTITION BY cs) AS max_views
- FROM
- (SELECT id,
- views,
- CASE
- WHEN views >= 350 THEN 1
- WHEN views <= 350 AND views >= 100 THEN 2
- WHEN views < 100 THEN 3
- END AS cs
- FROM stackoverflow.users
- WHERE location LIKE '%United States%' AND views !=0) dt
- ORDER BY max_views DESC, id