SELECT
    PF.PF_CODE AS "都道府県コード"
    , PF.PF_NAME AS "都道府県名"
    , ROUND(100.0 * INP_YES / (INP_YES + INP_NO + UNIDENTIFIED), 1) AS "入院率"
FROM
    HOSPITALIZATION AS HS
JOIN
    PREFECTURE AS PF
ON
    HS.PF_CODE = PF.PF_CODE
ORDER BY
    "入院率" DESC
    , PF.PF_CODE ASC;