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