select 
P.PF_CODE AS '都道府県コード',
P.PF_NAME AS '都道府県名',
ROUND(cast(100*INP_YES as real)/cast(INP_YES+INP_NO+UNIDENTIFIED as real),1) AS '入院率' 
FROM HOSPITALIZATION H
JOIN PREFECTURE P ON H.PF_CODE=P.PF_CODE
ORDER BY 
cast(100*INP_YES as real)/cast(INP_YES+INP_NO+UNIDENTIFIED as real) desc,
P.PF_CODE