Write a query to find the second-highest network usage day for each active customer account at AT&T.
Daily usage may be recorded in multiple rows for the same account and date. Return only active accounts with at least two distinct usage days.
account_id, account_name, usage_date, and total_usage_gb.account_id, then usage_date ascending.| Column | Type | Description |
|---|---|---|
| account_idPK | INT | Unique customer account identifier |
| account_name | VARCHAR(100) | Customer account display name |
| is_active | BOOLEAN | Whether the account is currently active |
| Column | Type | Description |
|---|---|---|
| usage_idPK | INT | Unique network usage record identifier |
| account_id | INT | Customer account associated with the usage record |
| usage_date | DATE | Date on which network usage occurred |
| usage_gb | NUMERIC(10,2) | Network usage measured in gigabytes |