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