SELECT
    P.PF_CODE AS 都道府県コード,
    P.PF_NAME AS 都道府県名,
    ROUND(CAST(H.INP_YES AS FLOAT)*100/CAST((H.INP_YES+H.INP_NO+H.UNIDENTIFIED)AS FLOAT),1) AS 入院率
FROM
    HOSPITALIZATION AS H
    INNER JOIN PREFECTURE AS P 
    ON P.PF_CODE = H.PF_CODE 
ORDER BY
    入院率 DESC,
    H.PF_CODE ASC;