0

Please login or register to vote for this query.

(click on this box to dismiss)

How many comments do I have for each score.

Q&A for scientists using computers to solve scientific problems

SELECT 
    c.*
FROM 
    Comments c
LEFT JOIN Posts q
ON
  c.PostId = q.Id
WHERE 
    c.UserId = 3027266
    AND q.OwnerUserId = 5432156
ORDER BY 
    c.Score DESC

fork query

edited sep 30 ray36576

created may 25 10 sam.saffron