Google Code-in

As one of the many editors of the English Wikipedia, I'm asking myself different thoughts regarding wiki statistics and I made a formal study of it. You can help me by answering these questions!

Basic to middle SQL skills are needed to perform these tasks depending on the indicated difficulty.

The target is to have for each question an SQL request and its result in the format of a table. Finally, we need to present the data visually as a graph. See linked page below for detailed instructions.

Top creators in this year

Articles are Wikipedia pages in main namespace, as the opposite of user or project pages that are in the namespace with the same name.

Question: We want to get the list of contributors that have created the most of articles this year.

Tip: use revision table with null rev_parent_id to get page creations. Be careful to omit redirect pages.

Difficulty: easy