Cities having Summer Temperature More than Jaipur in SQL

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
Cities having Summer Temperature More than Jaipur

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

Related:

Leave a Comment

sixteen − three =