0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

--select * from posts where commentCount>150
--select max(commentCount) from posts 
--select answerCount from posts group by answercount
--having count(AnswerCount) >1
--select distinct answercount from posts 
--where answercount in ()

--select count(answerCount) from posts 
--where answerCount in (select distinct answercount from posts)

/*SELECT 
       answerCount,count(*) AS numberOfRecords, 
FROM posts
GROUP BY answerCount
where answerCount is not null and answerCount>1
--HAVING c > 1
ORDER BY answerCount DESC*/
select count(id) from posts --where answercount=13

fork query

edited nov 21 19

created nov 21 19 anonymous