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 professional and enthusiast programmers

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

fork query

edited sep 30 23 ray36576

created may 25 10 sam.saffron