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.

Categorized user gadgets

Wikipedia users can create Javascripts scripts or CSS snipsets, called "user gadgets", that help them to perform repeated operations. They are located in the user space. Categories are a way to classifiate wiki pages. Usually, except some special ones, user gadgets shouldn't be categorized.

Question: We want to list all user JS gadgets that are categorized. This usually says that category code is not escaped correctly.

Tip: Use page table and its page_content_model column to extract all such pages. On the wiki page only post the number of pages, not the full list, using the same query with a count().

Difficulty: Average