For orders 16 to 30, show order_id and shipping_tier, using the first rule that
applies:
express when total_amount is 15000 or morestandard when shipping to Delhi, Mumbai, Bengaluru or Chennaieconomy for every other orderEnd your query with ORDER BY order_id.
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
| status |
| total_amount |
| shipping_city |
For orders 16 to 30, show order_id and shipping_tier, using the first rule that
applies:
express when total_amount is 15000 or morestandard when shipping to Delhi, Mumbai, Bengaluru or Chennaieconomy for every other orderEnd your query with ORDER BY order_id.
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
| status |
| total_amount |
| shipping_city |
| order_id | shipping_tier |
|---|---|
| 16 | NULL |
| 17 | standard |
| 18 | economy |
| 19 | standard |
| 20 | economy |
| 21 | economy |
| 22 | NULL |
| 23 | economy |
| 24 | standard |
| 25 | NULL |
| 26 | express |
| 27 | express |
| 28 | economy |
| 29 | standard |
| 30 | NULL |
Run query to see output