Find the Hottest and Coldest Temperature in SQL

Question:

Find the Hottest and Coldest Temperature

Select the  highest summer & lowest winter temperature and display the output as “HOT SUMMER” and “CHILL WINTER”

Find the Hottest and Coldest Temperature

Code:

Main.sql

select max(summertemp) as "HOT SUMMER" , min(wintertemp) as "CHILL WINTER" 
from town;

Recommended:

Leave a Comment

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