Rolling Average Over 7 Days

Equinor's offshore operations teams use sensor data to monitor temperature trends in production equipment. Write a PostgreSQL query that calculates a seven-day rolling average for each sensor.

Requirements

1. Exclude readings whose quality_status is not VALID or whose temperature is NULL.
2. Aggregate valid readings to one average temperature per sensor and calendar day.
3. Calculate a time-based rolling average covering the current day and the preceding six calendar days, partitioned by sensor.
4. Return every sensor-day with a daily average and a rolling average, rounded to two decimal places.
5. Sort the result by sensor_id and measured_day.