select 
    sum(ELEMENTARY) as 小学校,
    sum(MIDDLE) as 中学校, 
    sum(HIGH) as 高校, 
    sum(JUNIOR_CLG) as 短大, 
    sum(COLLEGE) as 大学,
    sum(GRADUATE) as 大学院 
from ENROLLMENT_STATUS WHERE SURVEY_YEAR = 2020 AND PF_CODE = 36000; 

select PREFECTURE.*,* from PREFECTURE
cross join (
    select "小学校" as KIND
    union all 
    select "中学校"
) KIND;