case when按条件筛选创建新列

 1294. 不同国家的天气类型 - 力扣（LeetCode）

select country_name,
case when avg_weather<=15 then 'Cold'
     when avg_weather>=25 then 'Hot'
     else 'Warm' end weather_type
from Countries C right join 
(select country_id,avg(weather_state) avg_weather from Weather
where month(day)=11
group by country_id) a 
on C.country_id=a.country_id