
SQL from a plain-English question
Arjun Mehta@arjun_codes
Fill in the blanks
0 of 3 filledThe prompt
Here's my schema:
paste CREATE TABLE statements
Write a Postgres / MySQL / SQLite query that answers: question.
Use CTEs instead of nested subqueries, name columns clearly and handle NULLs explicitly. After the query, explain in three bullet points how it works, and one thing that could make it slow on a large table, with the index that would fix it.
Fill in the blanks above to copy or open the prompt with your details in it.
1,955 uses640 saves380 likes10 remixes (0 public)Published 4 Sept 2026
A use is a copy, a fill-in copy, an insert or an open in an AI chat, counted once per person per day. Authors' own uses don't count.