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.0
    ,1) AS 入院率
FROM HOSPITALIZATION AS HP
INNER JOIN PREFECTURE AS PF
ON HP.PF_CODE=PF.PF_CODE
ORDER BY 入院率 DESC,
    PF.PF_CODE ASC
;