Q&A for medical specialists, students, dietitians, and anyone with health-related questions
/*What is the most number of comments on a single post?
How many posts have the exact same number of answers?
What is the current highest scored comment, and what post does it belong to?
select id, commentcount
order by commentcount desc
select answercount Tot_Ans_For_A_Post, count(id) Num_of_Post
group by answercount
select a.id, a.answercount, b.id, b.answercount
from posts a, posts b
where a.id != b.id
and a.answercount = b.answercount