Cities having Summer Temperature More than Jaipur in SQL

Question:

Cities having Summer Temperature More than Jaipur

 Write a query to display all the town names which has summer temperature more than “JAIPUR”. Output should be sorted on town name.

Cities having Summer Temperature More than Jaipur

Code:

Main.sql

select townname from town t
where t.summertemp>(select summertemp from town where townname='JAIPUR')
order by 1;

Recommended:

Leave a Comment

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

x