SELECT
    h.PF_CODE as 都道府県コード
    , PF_NAME as 都道府県名
    , INP_YES * 100.0 / (INP_YES + INP_NO + UNIDENTIFIED) as 入院率
FROM
    HOSPITALIZATION h
    INNER JOIN PREFECTURE p ON h.PF_CODE = p.PF_CODE
ORDER BY
    入院率 DESC, h.PF_CODE