I’m going back and practicing some of the beginner courses of SQL and I keep getting stuck writing a query for the following:
" Given a
cities table, write the query to select only the cities with
temperature less than 75."
The practice sessions don’t let you submit an answer until it’s correct so I’m not sure where I’m going wrong; it’s also difficult to tell what the parameters of the hypothetical table are.
Assuming temperature is an integer, I would think it’s a simple “WHERE” exercise:
WHERE temperature < 75;
Where am I going wrong? Or rather, what answer is the question wanting me to enter?
You must select a tag to post in this category. Please find the tag relating to the section of the course you are on E.g. loops, learn-compatibility
When you ask a question, don’t forget to include a link to the exercise or project you’re dealing with!
If you want to have the best chances of getting a useful answer quickly, make sure you follow our guidelines about how to ask a good question. That way you’ll be helping everyone – helping people to answer your question and helping others who are stuck to find the question and answer!