Prompt
Translate this question into Postgres SQL against tables [SCHEMA]. Question: "[QUESTION]". Output: (1) the query, (2) one assumption you made, (3) one edge case the query does NOT handle. Use CTEs over nested subqueries.
Translate this question into Postgres SQL against tables [SCHEMA]. Question: "[QUESTION]". Output: (1) the query, (2) one assumption you made, (3) one edge case the query does NOT handle. Use CTEs over nested subqueries.