Create an SQL query to get statistics for Top 10 users who were most thanked
Basic SQL skills are needed in this task.
As a normal editor of English Wikipedia, I would like to know how many thanks are given.
The target is to have a statistic page like this old one.
Thanks is a Mediawiki extension that allows one user to send a thanks notification to another.
"Replicas" is the common name for the SQL read-only database servers that allow everybody to run queries against publicly available wikis' data. The thanks logs can be found in the
logging table for each wiki. You can use https://quarry.wmflabs.org/ as a simple web interface to execute queries on replicas.
https://quarry.wmflabs.org/query/29486 is an example how to use the table.
In total, we want four queries (four GCI tasks). This task is about the query:
- Top 10 users who were most thanked
Here is what is wanted step by step: