Demo data · All use cases on this site are sample content written for development. They do not come from real sources or users, and scores are not real data.
CUCursorData analysisAdvancedAdded Oct 23Demo
Translate a business question into SQL with explanations
Generate a query against the real schema in your editor, with comments so non-engineers can review the logic.
Prompt
Using the table definitions in schema.sql, write a PostgreSQL query that answers: "[business question]" Requirements: - Build it step by step with CTEs - Above each CTE, add a comment explaining what it does - Finish by stating the query's assumptions and possible definition gaps
Steps
- 1Open the file that contains the schema
- 2Generate the query and run it on a read-only replica
- 3Confirm the metric definitions with the requester
Source
Demo case written by the ClawShow team for development. No external source.