Tags / self-join
Counting Single Matching Records with the Same AnswerCount Value in the Stack Exchange Database Using SQL Queries
Performing a Left Join on a Table Using the Same Column for Different Purposes: 3 Approaches to Achieving Your Goal
Understanding Self-Joins with BigQuery: A Comprehensive Guide