Find the names of the countries whose condition is sunny.SELECT country FROM location WHERE condition = 'sunny';SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = 'sunny');SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny');

Find the cities name with the condition and temperature from table 'whether' where condition = sunny or cloudy but temperature >= 60.SELECT city, temperature, condition FROM weather WHERE condition = 'cloudy' AND condition = 'sunny' OR temperature >= 60SELECT city, temperature, condition FROM weather WHERE condition = 'cloudy' OR condition = 'sunny' OR temperature >= 60SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature >= 60SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature >= 60

Find all the tuples having temperature greater than ‘Paris’.SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’)SELECT * FROM weather WHERE temperature > ‘Paris’ temperature

Find the names of cities with all entries whose temperature is in the range of 71 and 89SELECT * FROM weather WHERE temperature NOT IN (71 to 89);SELECT * FROM weather WHERE temperature NOT IN (71 and 89);SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;

Find the temperature in increasing order of all cities.SELECT city FROM weather ORDER BY temperature;SELECT city, temperature FROM weather;SELECT city, temperature FROM weather ORDER BY temperature;SELECT city, temperature FROM weather ORDER BY city;

Find all the cities whose humidity is 89SELECT city WHERE humidity = 89;SELECT city FROM weather WHERE humidity = 89;SELECT humidity = 89 FROM weather;SELECT city FROM weather;