It seems like you're trying to write a SQL query to find all cities with a humidity of 89. The correct syntax would be: ```sql SELECT city FROM weather WHERE humidity = 89; ``` This query will return all cities from the 'weather' table where the 'humidity' column has a value of 89.

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;

Question

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;

🧐 Not the exact question you are looking for?Go ask a question

Solution

It seems like you're trying to write a SQL query to find all cities with a humidity of 89. The correct syntax would be:

SELECT city FROM weather WHERE humidity = 89;

This query will return all cities from the 'weather' table where the 'humidity' column has a value of 89.

Similar Questions

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 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 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 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 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');

1/2

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.