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