SQL Query to Retrieve Sensor Data Within 480 Minutes for Device 'F321003124779dd-0bf7-4f08-a0b1-f66c917e9ddf4G'

SELECT t., a.arrivaltime FROM (SELECT c., d.tolerance FROM devicesensor AS a LEFT JOIN sensor AS c ON a.sensorid = c.sensorid LEFT JOIN dataalarm AS d ON c.dataalarmid = d.dataalarmid WHERE a.deviceid = 'F321003124779dd-0bf7-4f08-a0b1-f66c917e9ddf4G') t LEFT JOIN sensordata AS a ON t.sensorid = a.sensorid AND a.arrivaltime > NOW() - INTERVAL '480 MINUTE' ORDER BY a.arrivaltime DESC