Write a query using window functions to find the top active connections per data center node.
Use the provided node and connection tables. Include only active connections and return the two highest-bandwidth connections for each node.
node_id, node_code, connection_id, connection_name, bandwidth_mbps, and connection_rankconnection_idnode_id, then connection_rank, then connection_id| Column | Type | Description |
|---|---|---|
| node_idPK | INT | Unique identifier for the data center node |
| node_code | VARCHAR(30) | Operational code for the node |
| region | VARCHAR(40) | Geographic region containing the node |
| Column | Type | Description |
|---|---|---|
| connection_idPK | INT | Unique identifier for the connection |
| node_id | INT | Data center node associated with the connection |
| connection_name | VARCHAR(50) | Operational name of the connection |
| status | VARCHAR(20) | Current connection state |
| bandwidth_mbps | INT | Configured connection bandwidth in megabits per second |