SELECT 
    t1.PF_CODE as "都道府県コード",
    PF_NAME as "都道府県名",
    round(cast(INP_YES as REAL)/cast(INP_YES+INP_NO+UNIDENTIFIED as REAL)*100,1) as "入院率"
FROM HOSPITALIZATION AS T1
INNER JOIN
PREFECTURE AS T2
on 
t1.PF_CODE=t2.PF_CODE
ORDER BY
    "入院率" desc,
    "PF__CODE";