How would you write a query to find trends in customer activity by date?
Use the activity records to produce one daily summary. Exclude records where the activity date is missing.
activity_date, total_activities, and unique_customersactivity_date from earliest to latest| Column | Type | Description |
|---|---|---|
| activity_idPK | INT | Unique identifier for the activity record |
| customer_id | INT | Identifier of the customer associated with the activity |
| activity_date | DATE | Date on which the activity occurred |