Find the name of all cities with their temperature, humidity and countries.

Question

TuteeHUB · Accepted Answer

SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

TuteeHUB · Answer

SELECT city, temperature, humidity, country FROM location;

TuteeHUB · Answer

SELECT weather.city, temperature, humidity, country FROM weather, location;

TuteeHUB · Answer

SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;

1.	Find the name of all cities with their temperature, humidity and countries.
A.	SELECT city, temperature, humidity, country FROM location;
B.	SELECT weather.city, temperature, humidity, country FROM weather, location;
C.	SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;
D.	SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;
Answer» D. SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

Discussion