Write a PostgreSQL query to find active customers who had more than one system_error event on the same calendar day across their AVEVA sites. Return the customer ID, customer name, error date, and daily error count.
| Column | Type | Description |
|---|---|---|
| customer_id | ||
| customer_name | ||
| status |
| Column | Type | Description |
|---|---|---|
| site_id | ||
| customer_id | ||
| site_name |
| Column | Type | Description |
|---|---|---|
| event_id | ||
| site_id | ||
| event_type | ||
| event_time | ||
| severity |
Based on the sample data