Extra Space Storage operations leaders want a weekly view of how effectively store inquiries convert into reservations. Write a PostgreSQL query that combines daily inquiry and reservation metrics by store and date, then calculates the overall weekly reservation conversion rate.
store_inquiries_daily as the reporting base so weeks with inquiries remain visible even when no reservation record exists.store_id and activity date, then group records by the Monday week start returned by DATE_TRUNC('week', ...).| Column | Type | Description |
|---|---|---|
| store_idPK | INT | Identifier for the Extra Space Storage store |
| inquiry_datePK | DATE | Date inquiries were received |
| inquiry_count | INT | Number of inquiries received that day |
| Column | Type | Description |
|---|---|---|
| store_idPK | INT | Identifier for the Extra Space Storage store |
| reservation_datePK | DATE | Date reservations were recorded |
| reservation_count | INT | Number of reservations recorded that day |