아티클에서 시각화에 대해 읽었는데 이렇게 바로 쓸 줄은 ..
select case when age=60 then 60
when age=61 then 61
when age=62 then 62
when age=63 then 63
else 64 end age,
round(avg(charges),0) avg_charges
from sys.insurance i
group by 1
order by age
select region,
case when smoker='yes' then 'yes'
else 'no' end smoker,
round(avg(charges)avg_charges
from sys.insurance i
group by 1,2
order by 1 
