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