This Prompt What does it do?
Complex analytical reports in one query, with no extra processing in code.
Full text Prompt
Using the schema [schema], write a [MySQL 8/PostgreSQL] report that returns [request, e.g. seller rank per month, running total, and growth versus the previous month]. Use window functions like ROW_NUMBER, SUM OVER, and LAG with CTEs for readability, and comment each part. Show a few sample output rows.
English version (for image and video models)
Using the schema [schema], write a [MySQL 8/PostgreSQL] report that returns [request, e.g. seller rank per month, running total, and growth versus the previous month]. Use window functions like ROW_NUMBER, SUM OVER, and LAG with CTEs for readability, and comment each part. Show a few sample output rows.
Build a custom version for your project
Write your project details; to the end of Prompt is added, and you get a file that is given to the AI without extra explanation. Everything is built in your browser and no data goes to the server.
Preview of the final file
Frequently asked questions
Prompt “Window-function report query” — how do I use it?
Click the copy button, fill in any variables under “Fill in the variables”, and paste the text into ChatGPT, Claude, DeepSeek . For an answer in your language, add at the end: “Answer in my language”.
Is using this prompt free?
Yes. This prompt is from the collection awesome-persian-prompts With license CC0-1.0 collected and free for personal and commercial use.
پرامپتها مرتبط در “پایگاه داده”
AllA complete Laravel entity skeleton from database to model in one request.
A database structure that won't cause trouble later as the project grows.
Turns a reporting need into an accurate, optimised query without memorising syntax.
Brings legacy queries into safe, Laravel-style code, resistant to injection.
Learn how the database really executes your query.
Finds why a query is slow and offers a faster version with a suitable index.