Menu
Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. Find the names of the countries whose condition is sunny.

    2. A.

     SELECT country FROM location WHERE condition = 'sunny';
    B.

     SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');
    C.

     SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');
    D.

     SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny');

    View Answer

    Workspace

    View Answer

    Answer : Option B

    Explanation :

    Explanation Not Provided

Write your comments here:

Be The First To Comment