Re: 문제285. ( 한진 해운 SQL) 아래의 SQL 튜닝하세요 ~

[19기_안민영]

select gender, lower(telecom) as telecom, round(avg(age))
  from emp19 
  where gender is not null and telecom is not null
  group by grouping sets ( (gender), lower(telecom),())
  order by gender desc nulls last, telecom asc nulls last ;