Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy

  2. A.

     SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');

    B.

     SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

    C.

     SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');

    D.

     SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');

    View Answer

    Workspace

    Answer : Option A

    Explanation :

    Explanation Not Provided


Be The First To Comment