1294. Weather Type in Each Country.sql

select country_name, 
case 
when avg(weather_state)<=15 then 'Cold'
when avg(weather_state)>=25 then 'Hot'
else 'Warm' end as weather_type
from weather
join countries on weather.country_id=countries.country_id
where day between '2019-11-01' and '2019-11-30'
group by country_name