Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Provided is a table of temperature devices called devices. Write a query that will return the average thermostat temperature from each room with more

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To retrieve the average thermostat temperature from each room with more than 2 thermostats attached ... blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Design And Analysis Of Experiments

Authors: Douglas C., Montgomery

5th Edition

978-0471316497, 0471316490

More Books

Students explore these related Databases questions