Your question is 7-Day Rolling Network Traffic. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Juniper Networks uses daily telemetry from Juniper Mist and Junos devices to monitor network demand. Write a PostgreSQL query that calculates a seven-day rolling average of daily traffic and compares it with the immediately preceding seven-day period.
| Column | Type | Description |
|---|---|---|
| traffic_idPK | INT | Unique telemetry record identifier |
| traffic_date | DATE | Date of the traffic measurement |
| device_group | VARCHAR(40) | Juniper device group or product family |
| traffic_gb | NUMERIC(10,2) | Traffic volume in gigabytes |