Max Temperature SQL Query | Dataford Interview Questions

Given a dataset of sensor readings, write a SQL query to retrieve the maximum temperature recorded by a specific device over a defined time range.

Use device device-104 and include readings from 2025-01-10 00:00:00+00 through 2025-01-10 23:59:59+00. The start and end timestamps define an inclusive time range.

Output

Return one row with a column named max_temperature.
Include only readings from the specified device and time range.

Schema

sensor_readings

Column	Type	Description
reading_idPK	INT	Unique identifier for the sensor reading
device_id	VARCHAR(50)	Identifier of the device that produced the reading
recorded_at	TIMESTAMPTZ	Timestamp when the reading was recorded
temperature	DECIMAL(5,2)	Recorded temperature value

Your question is Max Temperature SQL Query. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem