0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers and students of the Korean language

--SELECT TOP 10
  --  q.id AS QuestionID--,
    --q.title AS QuestionTitle,
    --TIMESTAMPDIFF(MINUTE, q.creation_date, a.creation_date) AS TimeToAnswerInMinutes
--FROM 
  --  Posts q
--JOIN 
--    Tags t ON q.id = t.question_id
--JOIN 
--    Answers a ON q.id = a.question_id
--WHERE 
  --  Tags LIKE '%<java>%'
    --AND Tags LIKE '%<NullPointerException>%'
    --AND a.is_accepted = 1
--ORDER BY 
--    TimeToAnswerInMinutes ASC;

SElect top 10 id as user_id, sum(UpVotes) from users
group by id
order by 2

fork query

created dec 3 jon.doe46454