0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT 
    Id AS QuestionId, 
    Title, 
    (SELECT COUNT(*) 
     FROM Comments 
     WHERE Comments.PostId = Posts.Id) AS CommentCount
FROM Posts
WHERE PostTypeId = 1  -- Indicates a question
ORDER BY CommentCount DESC;

fork query

edited dec 11

created dec 11 anonymous