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 |