A list of the top 500 users with the highest average answer score excluding community wiki / closed posts or users with less than 10 answers
Q&A for those involved in the field of teaching Computer Science
SELECT REQUEST.ID, REQUEST.TITLE, REQUEST.BODY as REQUEST, RESPONSE.BODY as ANSWERS FROM (SELECT P.ID, P.TITLE, P.BODY, P.CREATIONDATE, T.TAGNAME FROM TAGS T JOIN POSTTAGS PT ON T.ID = PT.TAGID JOIN POSTS P ON P.ID = PT.POSTID WHERE TAGNAME = 'java' AND PARENTID IS NULL AND DATEDIFF(MONTH, CREATIONDATE, CURRENT_TIMESTAMP) < 6) AS REQUEST JOIN (SELECT * FROM POSTS WHERE PARENTID IN (SELECT P.ID FROM TAGS T JOIN POSTTAGS PT ON T.ID = PT.TAGID JOIN POSTS P ON P.ID = PT.POSTID WHERE TAGNAME LIKE 'java' AND DATEDIFF(MONTH, CREATIONDATE, CURRENT_TIMESTAMP) < 6)) AS RESPONSE ON RESPONSE.PARENTID = REQUEST.ID where REQUEST.ID = 77716741