Skip to content

SQL query from plain English

ChatGPT 7 views 0 copies Oct 3, 2026
Describe the data you need in normal words and get a correct, readable SQL query with an explanation and performance tips.

Prompt

Act as a SQL expert.

Database: [MySQL / PostgreSQL / SQLite / SQL Server]

Tables:
[table_name](column1 type, column2 type, ...)
[table_name](...)

What I want: [describe the result in plain English, e.g. "top 10 customers by total spend in 2025, with their order count"]

Please:
1. Write the query with clear aliases and comments
2. Explain how it works step by step
3. Mention assumptions you made about the data
4. Suggest indexes that would make it faster
5. Show a sample of what the result columns will look like

Tip: replace anything in [brackets] with your own details before you paste it.

#sql#database#queries#data analysis
Keep exploring

Similar prompts

Act as an expert email marketer and online course designer. Create a 7-day email course about [topic] for [target audience]. By the end of the course, readers should be able to [desired result]. Start with a short outline listing the 7 lesson titles, then write all 7 emails. For each day, include: 1. A subject line (u…

ChatGPT
Marketing & SEO

Turn any topic into a 7-day email course

Creates a complete 7-day email course from a single topic: subject lines, lessons, action steps and a closing call to action. Great for growing a newsletter, onboarding new customers or launching a lead magnet. Works just as well in Claude and Gemini.

2
Midjourney Featured
Photography

Drone aerial photography

Breathtaking top-down and high-angle aerial shots of coastlines, cities and landscapes, perfect for travel content and wallpapers.

1

A nostalgic 1980s arcade at night, kids playing glowing cabinets, neon lights and carpet patterns, a teen winning and cheering, handheld camera, warm VHS-style colors, fun and lively.

Kling
Video & Animation

Retro arcade scene

A nostalgic 1980s arcade full of neon.

1

Create a 12-month personal growth reading plan focused on [areas, e.g. habits, relationships, money, mindset]. Suggest one well-known book per month, why it's useful, and a practical exercise to apply each one.

ChatGPT
Personal Growth

Personal growth reading plan

A curated reading path for self-improvement.

1