Many of us have written and played with various stack exchange data explorer queries over time, but that site is terrible for keeping track of the organized useful list of queries we've scrambled.
I thought perhaps we could keep a list of them here as a sort of community wiki.
Any post of any query where the query may have some inaccuracies, posters feel free to correct the query, comment on the post that you did so, and edit the post to link the updated query.
Ideally we won't have lots of duplicates on here and we can keep a maintained list of most-current-most-correct queries for the various things we find useful/interesting.