SELECT
    hos.PF_CODE AS 都道府県コード,
    pre.PF_NAME AS 都道府県名,
    ROUND(CAST(hos.INP_YES AS REAL) / CAST((hos.INP_YES + hos.INP_NO + hos.UNIDENTIFIED) AS REAL) * 100,1) AS 入院率
FROM
    HOSPITALIZATION AS hos
LEFT JOIN
    PREFECTURE AS pre ON
    pre.PF_CODE = hos.PF_CODE
ORDER BY
    CAST(hos.INP_YES AS REAL) / CAST((hos.INP_YES + hos.INP_NO + hos.UNIDENTIFIED) AS REAL) DESC,
    hos.PF_CODE