Includes questions that have at least 5 million views.
Q&A about the site for professional linguists and others with an interest in linguistic research and theory
select top 20 format(q.creationdate,'yyyy-MMM-dd') dt, q.id [Post Link], q.viewcount [# Views], q.commentcount [#Comments], q.favoritecount [#Favs], q.score [Q Score], q.answercount [# Answers], avg(a.score)[Avg A Score], max(a.score)[Max A Score], q.Tags from posts q left join posts a on q.id=a.parentid where q.viewcount>1000000 and q.posttypeid=1 and a.posttypeid=2 group by format(q.creationdate,'yyyy-MMM-dd'),q.id,q.viewcount,q.answercount, q.commentcount,q.favoritecount,q.Score,q.tags order by q.viewcount desc