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