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