Write a SQL query to find the top three most used cell towers in a specific region over the last 24 hours at Verizon.
Use the region named Northeast and evaluate the time window relative to query execution. Return only towers with usage in that window.
tower_id, tower_name, region_name, and usage_countusage_count descending, then tower_id ascending to break ties| Column | Type | Description |
|---|---|---|
| region_idPK | INT | Unique region identifier |
| region_name | VARCHAR(100) | Verizon geographic region name |
| Column | Type | Description |
|---|---|---|
| tower_idPK | INT | Unique cell tower identifier |
| tower_name | VARCHAR(150) | Operational name of the cell tower |
| region_id | INT | Region containing the tower |
| Column | Type | Description |
|---|---|---|
| usage_event_idPK | INT | Unique tower usage event identifier |
| tower_id | INT | Tower associated with the usage event |
| event_time | TIMESTAMP | Timestamp when the usage event occurred |