SELECT
    "pref".PF_CODE "都道府県コード"
    , "pref".PF_NAME "都道府県名"
    -- , INP_YES "入院者あり"
    -- , INP_NO "入院者なし"
    -- , UNIDENTIFIED "不詳"
    -- , INP_YES + INP_NO + UNIDENTIFIED "合計"
    , ROUND(INP_YES / CAST((INP_YES + INP_NO + UNIDENTIFIED) AS FLOAT) * 100, 1) "入院率"
FROM
    HOSPITALIZATION "hosp"
INNER JOIN
    PREFECTURE "pref" ON "hosp".PF_CODE = "pref".PF_CODE
ORDER BY
    "入院率" DESC,
    "都道府県コード" ASC
;