Codible SQLite video 11: SQL query with subquery, both referencing the same table
SQL query with subquery, with the same table being referenced in both query and subquery
SQL query with subquery, with the same table being referenced in both query and subquery