select HZ.PF_CODE AS 都道府県コード
       , PF.PF_NAME AS 都道府県名
       , round((cast(HZ.INP_YES As real)/cast(HZ.INP_YES+HZ.INP_NO+HZ.UNIDENTIFIED as real))*100,1) AS 入院率
from HOSPITALIZATION AS HZ
inner join PREFECTURE AS PF ON HZ.PF_CODE = PF.PF_CODE
ORDER BY
    入院率 DESC
    , HZ.PF_CODE ASC;