Menu
Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

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

    2. 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;

    View Answer

    Workspace

    View Answer

    Answer : Option C

    Explanation :

    Explanation Not Provided

Write your comments here:

Be The First To Comment