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.

Articles created by bots

Bots are Wikipedia special accounts that are used by automated software.

Question: We want to know the number of articles created by each bot on the French Wikipedia, then the total number.

Tip: use revision table with null rev_parent_id to get page creations, and user_groups table to get extract bots. If you come across a query timeout problem (take too long compute time), you can calculate that only for 2018 revisions (rc_timestamp >= 201800000000)

Difficulty: average