Display based on Summer Temperature of Cities in SQL

Question:

Display based on Summer Temperature of Cities

  Display the town names whose summer temperature is above 30 degrees. Display the result in the descending order of summer temperature.

Quiz for Exam - Display based on Summer Temperature of Cities

Code:

Main.sql

select townname 
from town 
where summertemp>30 
order by summertemp desc;

Recommended:

Leave a Comment

Your email address will not be published. Required fields are marked *

x