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
Please attach StackOverflow database and write a single SQL statement to find out top posters per each year per each post type including comments and total points. 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 point per each comment points per each question points per each answer.
begintabularcccccc
hline Year & Rank & Answer & Question & Comment & Total
hline & & Jon Skeet: & Thomas Owens: & Jon Skeet: & Jon Skeet:
hline & & Joel Coehoorn: & leora: & SLott: & Joel Coehoorn:
hline & & Marc Gravell: & Brian R Bondy: & Jonathan Leffler: & Marc Gravell:
hline & & Jon Skeet: & Lo Lopold Hertz : & Jon Skeet: & Jon Skeet:
hline & & Marc Gravell: & Edward Tanguay: & John Saunders: & Marc Gravell:
hline & & Alex Martelli: & mrblah: & Marc Gravell: & John Saunders:
hline & & Nick Craver: & Blankman: & Pekka : & Nick Craver.
hline & & Hans Passant: & Jitendra Vyas: & Nick Craver: & Pekka :
hline & & Jon Skeet: & & BalusC: & Hans Passant:
hline
endtabular
Bonus Question points: Is there anyone who was asking for double negation queries in StackOverflow If so who is that? Please write a single SQL statement to find the answer.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
