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