Your question is Weekly Merchant Launch Metrics by City. Start with the requirements and the three tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
You are asked to write a SQL query that pulls the key metrics for a new merchant launch by city and week. The output should show weekly launch performance for each city, including merchant counts and core activity metrics, using PostgreSQL-compatible SQL.
| Column | Type | Description |
|---|---|---|
| merchant_idPK | INT | Unique merchant identifier |
| city_id | INT | City where the merchant launched |
| launch_date | DATE | Date the merchant launched |
| launch_status | VARCHAR(20) | Launch status such as launched or canceled |
| Column | Type | Description |
|---|---|---|
| city_idPK | INT | Unique city identifier |
| city_name | VARCHAR(100) | Display name of the city |
| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique order identifier |
| merchant_id | INT | Merchant that received the order |
| order_date | DATE | Date the order was placed |
| order_amount | NUMERIC(10,2) | Order value |
| order_status | VARCHAR(20) | Order status such as completed or canceled |