You want to calculate the hourly average temperature for multiple rooms stored in InfluxDB on Raspberry Pi. Which query correctly groups data by room and hour?

hard🚀 Application Q8 of 15

Raspberry Pi - Data Logging and Databases

ASELECT mean("temperature") FROM "room_temps" WHERE time(1h) GROUP BY "room"

BSELECT mean("temperature") FROM "room_temps" GROUP BY "room" HAVING time(1h)

CSELECT mean("temperature") FROM "room_temps" GROUP BY time(1h) AND "room"

DSELECT mean("temperature") FROM "room_temps" GROUP BY time(1h), "room"

Step-by-Step Solution

Solution:

Step 1: Understand GROUP BY syntax in InfluxDB
Grouping by time intervals and tags uses comma-separated list: GROUP BY time(1h), "room".
Step 2: Evaluate each option
SELECT mean("temperature") FROM "room_temps" GROUP BY time(1h), "room" uses correct syntax; B misuses HAVING; A misuses WHERE; D uses invalid AND.
Final Answer:
SELECT mean("temperature") FROM "room_temps" GROUP BY time(1h), "room" -> Option D
Quick Check:
GROUP BY time and tag = comma-separated list [OK]

Quick Trick: Use comma to separate time and tag in GROUP BY [OK]

Common Mistakes:

MISTAKES

Using HAVING instead of GROUP BY
Using WHERE for grouping
Using AND instead of comma

Master "Data Logging and Databases" in Raspberry Pi

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More Raspberry Pi Quizzes

You want to calculate the hourly average temperature for multiple rooms stored in InfluxDB on Raspberry Pi. Which query correctly groups data by room and hour?

Step 1: Understand GROUP BY syntax in InfluxDB

Step 2: Evaluate each option

Final Answer:

Quick Check:

Want More Practice?