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

mhmadesk

Save to bookmark

2022-07-08

410

Medium

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

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

Database, MCQ Questions, Database MCQ-questions,

mhmadesk

2022-07-08

need an explanation for this answer? contact us directly to get an explanation for this answer

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

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)