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 select max(postid),max(score) from comments select postId,score from comments where score=1424