PhraseryPhrasery homeGet Phrasery
Data & SQL21 categories

Explain this query to me line by line

You inherited a 200-line query and need to understand it before changing it.

LongSQLunderstandingonboarding
Explain the SQL below to a competent engineer who has never seen this schema.

Structure your answer:
1. **In one sentence**: what question does this query answer?
2. **The grain**: what does one row of the result represent? State it precisely.
3. **Walkthrough**: work outwards from the innermost subquery or first CTE. For each, say what it produces and why the next step needs it.
4. **The joins**: for each, say whether it can multiply rows, and what the join key means in business terms.
5. **Filters**: list every WHERE and HAVING condition and what it excludes.
6. **Suspicious**: anything that looks like it was added to patch a symptom, any filter that silently drops rows, any assumption about the data I should verify.

Where you are inferring what a column means from its name, say so.

Query:

Making it yours

  • Paste your own material where the prompt asks for it. Everything above that line is instruction, not content.
  • Delete any rule that does not apply to you. A shorter prompt that fits beats a thorough one that does not.
  • If the answer comes back vague, add a line saying what you do not want. Constraints work better than encouragement.

Writing and reading queries. Drafting SQL from a plain question, making an inherited query legible, and moving it between dialects.

Related prompts

Write the query from a plain-language questionYou know exactly what you want to know and not how to express it in SQL.Solve this with a window functionYou're about to write a self-join and suspect there's a cleaner way.Port this query to another SQL dialectMoving a query between Postgres, BigQuery, Snowflake, MySQL, or SQLite.Build and explain a spreadsheet formulaWhen the lookup keeps returning N/A and the nesting is four deep.Explain this query in three sentencesSomeone handed you a query and you need the gist before you touch it.Rewrite this without nested subqueriesFour levels of nesting and nobody can read it, including you.

Keep this one

Phrasery saves prompts with a right-click and puts them back the same way. Add this to your own library in one click.

Add to your browser — free