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