Menu
Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70oF.

    2. A.

     SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70;
    B.

     SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;
    C.

     SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;
    D.

     SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70;

    View Answer

    Workspace

    View Answer

    Answer : Option C

    Explanation :

    Explanation Not Provided

Write your comments here:

Be The First To Comment