Question: 4 . Please attach StackOverflow 2 0 1 0 database and write a single SQL statement to find out top 3 posters per each year

4. Please attach StackOverflow2010 database and write a single SQL statement to find out top 3 posters per each year per each post type including comments and total points. (35 points) The output should match to the following;
Posting type should be (Answer or Question or Comment), other types are ignored.
For Answer posting, the output format should be "User Display Name: Count of Answers".
For Question posting, the output format should be "User Display Name: Count of Questions".
For Comment posting, the output format should be "User Display Name: Count of Comments".
For Total posting, the output format should be "User Display Name: Total Points".
The total points \(=1\) point per each comment +2 points per each question +3 points per each answer.
\begin{tabular}{|c|c|c|c|c|c|}
\hline Year & Rank & Answer & Question & Comment & Total \\
\hline 2008 & 1 & Jon Skeet: 1288 & Thomas Owens: 139 & Jon Skeet: 1418 & Jon Skeet: 5290\\
\hline 2008 & 2 & Joel Coehoorn: 874 & leora: 125 & S.Lott: 838 & Joel Coehoorn: 3390\\
\hline 2008 & 3 & Marc Gravell: 855 & Brian R. Bondy: 121 & Jonathan Leffler: 804 & Marc Gravell: 3295\\
\hline 2009 & 1 & Jon Skeet: 5117 & Lo Lopold Hertz ??: 695 & Jon Skeet: 6121 & Jon Skeet: 21504\\
\hline 2009 & 2 & Marc Gravell: 3753 & Edward Tanguay: 577 & John Saunders: 4510 & Marc Gravell: 15544\\
\hline 2009 & 3 & Alex Martelli: 2794 & mrblah: 542 & Marc Gravell: 4265 & John Saunders: 11347\\
\hline 2010 & 1 & Nick Craver: 5899 & Blankman: 797 & Pekka ??: 11042 & Nick Craver. 26298\\
\hline 2010 & 2 & Hans Passant: 4958 & Jitendra Vyas: 662 & Nick Craver: 8591 & Pekka ??: 23308\\
\hline 2010 & 3 & Jon Skeet: 4926 & & BalusC: 6993 & Hans Passant: 20833\\
\hline
\end{tabular}
Bonus Question (5 points): Is there anyone who was asking for double negation queries in StackOverflow2010? If so, who is that? Please write a single SQL statement to find the answer.
4 . Please attach StackOverflow 2 0 1 0 database

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!