select
    pf_code as 都道府県コード,
    pf_name as 都道府県名,
    round((100.0 * INP_YES) / (INP_YES + INP_NO + UNIDENTIFIED + 0.0),1) as 入院率
from
    hospitalization
    innner join prefecture using (pf_code)
order by 入院率 desc, pf_code asc;