Goal: Make the list of Top 50 users who closed most questions on a site.
This means the questions that actually got closed, not pending close votes/flags. Deleted questions are excluded from consideration, since they are not available in Data Explorer.
Using the PostHistory table, it is easy to find how many questions were closed by a particular user: example. But I don't see a way to produce the list of Top N closers.
The relevant column of PostHistory table is Text, which contains the list of voters in object notation:
{"Voters":[{"Id":11176,"DisplayName":"TMM"},{"Id":9849,"DisplayName":"Davide Giraudo"},{"Id":125084,"DisplayName":"symmetricuser"},{"Id":36150,"DisplayName":"saz"},{"Id":147263,"DisplayName":"Weapon of Choice"}]}
So, if I download the rows with PostHistoryTypeId=10
and run some script on the data, I can make a Top 50 list this way. But this is a really awkward way: it would be much better to have a SEDE query returning such a list. Is this even possible? My knowledge of SQL is not enough for this.