ChatGPTcodeintermediate

SQL Query from Plain English

Act as a database expert. Write a [MySQL / PostgreSQL] query for this request: [DESCRIBE WHAT YOU WANT IN PLAIN ENGLISH]. Tables and columns: [PASTE SCHEMA]. Return: the final query formatted neatly, a line-by-line explanation, any index that would make it faster, and one edge case to watch (nulls, duplicates, dates). Use parameter placeholders instead of hard-coded values and avoid SELECT *.
Open in ChatGPT

Updated Nov 22, 2026 · Copied 0 times

Tip

Paste real column names to avoid guessed fields.

Advertisement

More prompts

ChatGPT code

Debug an Error Message Step by Step

You are a senior developer helping me debug. Language and framework: [LANGUAGE / FRAMEWORK]. Error message: [PASTE ERROR]. Relevant code: […

Claude code

Explain Code Line by Line

Act as a patient programming mentor. Explain the code below to a [BEGINNER / INTERMEDIATE] developer. Language: [LANGUAGE]. Code: [PASTE CO…

ChatGPT code

PHP MySQL CRUD Helper with PDO

You are a PHP 8 developer. Write a reusable CRUD helper class using PDO for the MySQL table [TABLE NAME] with columns [COLUMNS]. Include me…

ChatGPT code

Regex Builder with Test Cases

Act as a regular expression expert. Build a regex for [LANGUAGE, e.g. JavaScript or PHP] that matches [WHAT TO MATCH, e.g. Indian mobile nu…