Microtask - 1 of T304826
[Time estimate to complete: 1-3 hours]
Task: Write a SQL query on https://quarry.wmcloud.org/ to get a list of "unique" uploaders to the Wikimedia Commons category: Images from Wiki Loves Earth 2014, who have created their Wikimedia account during the campaign period i.e. May and June 2014. The output should include user_name and their account registration timestamp.
Submission instructions: After a successful output, submit the link (copy from url) along with Phabricator username privately to me @KCVelaga on Zulip (don't post the link publicly). Along with the code, do write explanatory comments about the approach and purpose of various steps. I will confirm whoever has submitted the micro-task here and your application as well.
Hints:
- Check out how categories work on Wikimedia Commons: https://commons.wikimedia.org/wiki/Commons:Categories
- Tables that will help you to get the required data: Revision, Category links, Actor, and User
- When a file is uploaded, it is considered as page creation!
Note:
- If during evaluation, if it is identified that the code is copied, the micro-task submission will be considered as invalid.
- For any doubts, you can post them to this ticket or ask on Zulip stream #gsoc2022: campaign retention metrics dashboard