select
    h.PF_CODE as `都道府県コード`
    , p.PF_NAME as `都道府県名`
    , Round(CAST(h.INP_YES as REAL) / (CAST(h.INP_YES as REAL) + CAST(h.INP_NO as REAL) + CAST(h.UNIDENTIFIED as REAL)) * 100, 1) as `入院率`
from
    HOSPITALIZATION h
inner join
    PREFECTURE p on p.PF_CODE = h.PF_CODE
order by
    CAST(h.INP_YES as REAL) / (CAST(h.INP_YES as REAL) + CAST(h.INP_NO as REAL) + CAST(h.UNIDENTIFIED as REAL)) * 100 DESC
;