You are given Uber trip and Uber Eats order data. Write a SQL query to find, for each calendar day, the number of distinct users who completed at least one ride and placed at least one meal order on that same day. A user should only be counted once per day even if they took multiple rides or placed multiple orders.
uber_trips| column | type | description |
|---|---|---|
| trip_id | INT | Unique trip identifier |
| user_id | INT | User who requested the ride |
| trip_date | TIMESTAMP | Timestamp when the ride occurred |
| trip_status | VARCHAR(20) | Ride status |
| city | VARCHAR(50) | City where the ride happened |
uber_eats_orders| column | type | description |
|---|---|---|
| order_id | INT | Unique order identifier |
| user_id | INT | User who placed the order |
| order_date | TIMESTAMP | Timestamp when the order was placed |
| order_status | VARCHAR(20) | Order status |
| merchant_name | VARCHAR(100) | Restaurant or merchant name |
uber_trips: (102, 2, '2024-04-01 18:40:00', 'completed', 'San Francisco'), (103, 2, '2024-04-01 20:10:00', 'completed', 'San Francisco'), (108, 7, '2024-04-03 08:00:00', 'completed', NULL)
uber_eats_orders: (202, 2, '2024-04-01 19:15:00', 'delivered', 'Shake Shack'), (205, 4, '2024-04-02 12:30:00', 'delivered', ''), (208, 7, '2024-04-03 09:00:00', 'delivered', NULL)
| activity_date | users_with_ride_and_meal |
|---|---|
| 2024-04-01 | 2 |
| 2024-04-02 | 1 |
| 2024-04-03 | 1 |