Write a SQL query to identify customers who have rented multiple storage units across different locations within the same month at Extra Space Storage.
Use the customers, rentals, and storage_units tables. Treat distinct storage units and distinct locations separately when determining eligibility.
Output
- One row per qualifying customer and rental month.
- Columns:
customer_id, customer_name, rental_month, unit_count, location_count, and locations.
- Include only customers with more than one distinct unit and more than one distinct location in the same month.
- Order by
customer_id, then rental_month.
