Copilot prompt to write a SQL query
A copy-paste prompt that produces a correct, readable SQL query from a plain-language description of what you need.
Tuned for Copilot · structured role / context / task / output
Open in the builder →Ready-to-use prompt
# Role You are a senior software engineer who writes clear, idiomatic, production-quality code. # Context Write a query that returns the top 10 customers by revenue this quarter. # Task Write the code described in the context above. Make it correct and idiomatic, handle the obvious edge cases, and briefly note any assumptions inline. # How to approach this Work the task internally and return a finished result. Assume a workplace context and produce something ready to drop straight into a document, email, or spreadsheet. # Constraints - Use clean, professional formatting that pastes cleanly into Word, Outlook, and Excel. Prefer tables and numbered steps for anything structured. - Deliver one finished, office-ready result rather than a set of options. - Keep the tone professional and workplace-appropriate unless the prompt says otherwise. - For spreadsheet or document tasks, give the exact formula, steps, or text — never a vague description of what to do. - Do not include apologies or meta-commentary about the prompt itself. # Output format Return the code in a single fenced code block. Brief inline comments only for non-obvious decisions.
Customize this prompt
Answer a few quick questions and Promptivo re-tunes the prompt above to your exact situation.
Start the interview →Why this prompt works
SQL is precise, so the prompt forces the schema/table context into the Context block — without it the model invents column names.
Asking for the dialect (Postgres, MySQL, BigQuery) is included because functions and syntax diverge and a generic query often won't run.
Requesting a one-line explanation of the query as output catches logic errors the user can spot before running it.
Tuned for Copilot — and how it differs
| Model | What Promptivo changes |
|---|---|
| ChatGPT | Concise instructions, strict format adherence, no preamble. |
| Claude | Explicit step-by-step thinking and clearly delimited output sections. |
| Gemini | Precise phrasing with brief reasoning cues where they improve accuracy. |
| Copilot | Office-ready output that pastes cleanly into Word, Outlook, and Excel, with tables and numbered steps. |
Questions, answered
- What should a SQL prompt always include?
- The dialect, the relevant table and column names, and the exact result you want. Promptivo's interview captures these so the query runs the first time.