Assignment
Questions
Question 1 - All Data from Device_12
SELECT * FROM sensor_data WHERE device = 'device_12';
Excerpt of Results
2 - Count the number of records your device sent
SELECT count(*) FROM sensor_data WHERE device = 'device_12';
3 - Maximum temperature reading your device sent
SELECT device, max(reading)
FROM sensor_data
WHERE measurement = 'temperature' AND device = 'device_12'
GROUP BY device
Notes - Running the Queries
Database after creating the 4 entries.
Database entries for device_12
Running the Queries