Provided is a table of temperature devices called devices. Write a query that will return the...

 

Transcribed Image Text:

Provided is a table of temperature devices called devices. Write a query that will return the average thermostat temperature from each room with more than 2 thermostats attached. The results should be listed in descending order based on the room name and should round to the nearest whole number without any decimals. Example TableName: DEVICES RoomName Kitchen Kitchen Kitchen Bedroom Bedroom Bedroom Output: Kitchen 72 Device Type Temperature Thermostat Thermostat Thermostat Thermostat Thermostat Temp Sensor 71 72 73 68 68 68 Provided is a table of temperature devices called devices. Write a query that will return the average thermostat temperature from each room with more than 2 thermostats attached. The results should be listed in descending order based on the room name and should round to the nearest whole number without any decimals. Example TableName: DEVICES RoomName Kitchen Kitchen Kitchen Bedroom Bedroom Bedroom Output: Kitchen 72 Device Type Temperature Thermostat Thermostat Thermostat Thermostat Thermostat Temp Sensor 71 72 73 68 68 68

Answer rating: 100% (QA)

To retrieve the average thermostat temperature from each room with more than 2 thermostats attached ... View the full answer