This question asks about an SEDE tutorial, which doesn't really exist. The answer there suggests that you can look at existing queries, which I think is how most SEDE users have learned, but that has a couple challenges:

• There are a lot of queries out there.

• Some of them might not be good examples (expensive, unnecessarily cumbersome, obscurely clever, fragile).

So it would be nice to have a small number of good examples, ones that are models we want people to emulate and that are comprehensible to SEDE beginners. This would be a nice supplement to the schema documentation.

So my question: if we wanted to pick, or write, a small number (half a dozen?) of good solid examples to use in an SEDE tutorial, which ones should they be? Please propose (or specify) candidates or, better yet, sets of candidates that together would teach people to get the data they want and not tear out too much hair or pound SE's servers mercilessly.