Q&A about the site for software quality control experts, automation engineers, and software testers
-- Enter Query Title -- Enter Query Description --select count(*) from Comments where Userid = 22656; WITH Rankings AS ( select Top 1000 Reputation, Id from Users order by Reputation Desc) Select count(Id), UserId from Comments where UserId in (Select Id from Rankings where Id = Comments.UserId) group by UserId;