select
    PF_CODE as 都道府県コード
    , PF_NAME as 都道府県名
    , round((cast(INP_YES as real) / cast(INP_YES + INP_NO + UNIDENTIFIED as real)) * 100, 1) as 入院率
from
    HOSPITALIZATION
left join PREFECTURE
    using(PF_CODE)
order by 3 desc, 1