Q&A for professionals and students of engineering
--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 * from (select answerCount,count(id) AS numberOfRecords FROM posts where answerCount is not null Group BY answerCount) as M where numberOfRecords >1 ORDER BY answerCount --select count(id) from posts --where answercount=13