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 that redirect to non content pages

Wikipedia articles can be a redirect to another one. It's also technically possible to redirect to any other Wiki page, like a user or a talk one. In this case it's quite possible that this redirect should not be kept and probably deleted.

Question: We want to get the number of articles that redirect to a page that is not an article itself.

Tip: use both redirect and page tables.

Difficulty: Easy to average.