Meesho's grocery analytics team wants to compare assortment pricing and order reliability across two fulfillment locations. Write a PostgreSQL query for calendar year 2024 using the two tables below.
product_id and restrict orders to 2024.Cancelled or Not Delivered, using all 2024 orders as the denominator.| Column | Type | Description |
|---|---|---|
| product_idPK | INT | Unique grocery product identifier |
| product_name | VARCHAR(100) | Grocery product name |
| location | VARCHAR(50) | Fulfillment location |
| price | NUMERIC(10,2) | Listed product price in rupees |
| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique order identifier |
| product_id | INT | Ordered product identifier referencing products.product_id |
| order_date | DATE | Date the order was placed |
| status | VARCHAR(30) | Delivery outcome such as Delivered, Cancelled, or Not Delivered |