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.

 User gadgets creators

Wikipedia users can create Javascripts scripts or CSS snippets, called "user gadgets", that help them to perform repeated operations. They are located in the user space.

Question: We want to know the percentage of users that have one or more Javascript page in their subpages, and the same value for CSS ones.

Tip: Use page table and its page_content_model column to extract all such pages. To avoid counting multiple times same users, split pages titles to get usernames and select distinct results.

Difficulty: Average.