Explore prompts · PromptByte

Share a prompt Sign in

Trending Newest Top

Tag: query-generation
Clear all

code · sql
```
**Assumptions**

- `order_items.order_id` joins to `orders.id`, and `products.category_id` joins to `categories.id`. These are inferred from the naming convention, since no foreign keys were listed.
- "Last 90 days" is measured against `orders.order_date` relative to today, inclusive of today.
- Revenue is `quantity * unit_price` summed over line items; there is no discount or tax column in the schema, so none is applied.
- Cancelled orders are excluded. If `status` uses different values than `'
```
Code preview: **Assumptions** - `order_items.order_id` joins to `orders.id`, and `products.category_id` joins to `categories.id`. These are inferred from the naming convention, since no foreign keys were listed. - "Last 90 days" is measured against `orders.order_date` relative to today, inclusive of today. - Revenue is `quantity * unit_price` summed over line items; there is no discount or tax column in the schema, so none is applied. - Cancelled orders are excluded. If `status` uses different values than `'
SQL query generator from a plain-English request
Converts a natural-language data requirement plus a table schema into a syntactically correct SQL query for a named database, with its assumptions stated up front.
CodeData & Analysis OpenAI · GPT-5.5
PL@promptbyte1w
Score 0
0 comments1 results