プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答
--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(id) AS numberOfRecords FROM posts where answerCount is not null --and answerCount>1 GROUP BY answerCount ORDER BY answerCount DESC --select count(id) from posts --where answercount=13