Your question is SQL for Inquiry-to-Reservation Conversion. Start with the requirements and the two 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.
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 |