Untitled

From Red Giraffe, 4 Months ago, written in Plain Text, viewed 53 times.

URL http://codebin.org/view/29121db3 Embed

Download Paste or View Raw

SELECT
  id,
  views,
  CASE
    WHEN users.views >= 350 THEN 'Группа 1'
    WHEN users.views >= 100 THEN 'Группа 2'
    ELSE 'Группа 3'
  END AS user_group
FROM
  stackoverflow.users
WHERE
  users.location LIKE 'Canada'
  AND users.views != 0;

Reply to "Untitled"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?