select
    HOSPITALIZATION.PF_CODE as "都道府県コード",
    PF_NAME as "都道府県名",
    round((cast(INP_YES as real) / (cast(INP_YES as real) + cast(INP_NO as real) + cast(UNIDENTIFIED as real))) * 100, 1) as "入院率"
from
    HOSPITALIZATION
inner join
    PREFECTURE
on
    HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
order by
    `入院率` desc, `都道府県コード` asc
;