This topic became too long to be easily searched and has been broken down into separate topics. If you have any questions about how to write a Data Explorer query, or have one to share, please start a new topic in the data & reporting category and tag it with the sql-query tag.
For an alternative searchable list of queries that were in this topic, see @SidV’s query list on GitHub.