Untitled

From Дмитрий, 4 Months ago, written in Plain Text, viewed 74 times.

URL http://codebin.org/view/255c708b Embed

Download Paste or View Raw

WITH name_close AS (SELECT *
                    FROM stackoverflow.vote_types
                    WHERE name = 'Close'),
table_dinish AS (SELECT user_id,
                        COUNT(vote_type_id)
                 FROM stackoverflow.votes AS v
                 JOIN name_close AS nc ON nc.id = v.vote_type_id
                 Group BY user_id 
                 ORDER BY COUNT(vote_type_id) DESC
                 LIMIT 10)
SELECT *
FROM table_dinish
ORDER BY count, user_id

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?