Untitled

From Wet Mockingbird, 1 Year ago, written in Plain Text, viewed 229 times.
URL http://codebin.org/view/148f4c38 Embed
Download Paste or View Raw
  1. SELECT id,
  2.        cs,
  3.        MAX (views) OVER (PARTITION BY cs) AS max_views
  4. FROM
  5. (SELECT id,
  6.        views,      
  7.        CASE
  8.            WHEN views >= 350 THEN 1
  9.            WHEN views <= 350 AND views >= 100 THEN 2        
  10.            WHEN views < 100 THEN 3
  11.        END AS cs
  12. FROM stackoverflow.users
  13. WHERE location LIKE '%United States%' AND views !=0) dt
  14. ORDER BY max_views DESC, id

Reply to "Untitled"

Here you can reply to the paste above