select postid, COUNT(*) As NumAns FROM Comments INNER JOI...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

select postid, COUNT(*) As NumAns FROM Comments
INNER JOIN Posts ON comments.PostId = Posts.Id
group by postid
order by count(*) Desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results