create temporary table height as
select
  age,
  gender_code,
  round(avg(average_value),1) height,
  count(1) cnt
from
  school_health
where
  category_code = '10'
  and survey_year = 2019
group by age, gender_code
;

create temporary table weight as
select
  age,
  gender_code,
  round(avg(average_value),1) weight,
  count(1) cnt
from
  school_health
where
  category_code = '20'
  and survey_year = 2019
group by age, gender_code
;

create temporary table h_ans as
select
  m.age,
  m.gender_code,
  h.height H_AVG,
  round(100.0 * sum(IIF(round(m.average_value,1) >= h.height, 1, 0)) / cast(h.cnt as real), 1) H_PER
from
  school_health m
left join
  height h
  on m.age = h.age and m.gender_code = h.gender_code
where
  m.category_code = '10'
  and m.survey_year = 2019
group by m.age, m.gender_code
;

create temporary table w_ans as
select
  m.age,
  m.gender_code,
  w.weight W_AVG,
  round(100.0 * sum(IIF(round(m.average_value,1) >= w.weight, 1, 0)) / cast(w.cnt as real), 1) W_PER
from
  school_health m
left join
  weight w
  on m.age = w.age and m.gender_code = w.gender_code
where
  m.category_code = '20'
  and m.survey_year = 2019
group by m.age, m.gender_code
;

select
  h.age AGE,
  IIF(h.gender_code = '20', 'MALE', 'FEMALE') GENDER,
  round(h.H_AVG,1) H_AVG,
  (h.H_PER || '%') H_PER,
  round(w.W_AVG,1) W_AVG,
  (w.W_PER || '%') W_PER
from
  h_ans h
inner join
  w_ans w
  on h.age = w.age and h.gender_code = w.gender_code
order by AGE desc, GENDER
;