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
    PREFECTURE
inner join
    HOSPITALIZATION
using(PF_CODE)
order by PF_CODE desc