Data & Analysis
Turn a business question into a SQL query
Describe your tables and the question you need answered and get a correct, commented SQL query with assumptions spelled out.
No ratings yet
3fill-in fields0copies
Tag
#SQL
6 prompts tagged SQL.
6 prompts
- Data & Analysis
Cohort and retention analysis plan with code
Set up a proper cohort retention analysis, from defining cohorts and the activity event to producing the table and reading it correctly.
No ratings yet6fill-in fields0copies - Data & Analysis
Review and optimize a SQL query
Paste a slow or suspicious SQL query and get correctness checks, performance fixes, and a cleaner rewrite you can verify.
No ratings yet4fill-in fields0copies - Coding
Design a database schema from requirements
Turn feature requirements into a normalized schema with keys, constraints, indexes and the tradeoffs explained.
No ratings yet4fill-in fields0copies - Coding
Optimize a slow SQL query
Find why a query is slow and get a faster version, index suggestions and a way to prove the improvement.
No ratings yet5fill-in fields0copies - Coding
Write a SQL query from plain English
Describe the question and your tables, and get a correct, readable query with an explanation and edge cases.
No ratings yet3fill-in fields0copies