select H.PF_CODE as '都道府県コード', P.PF_NAME as '都道府県名', round((cast(H.INP_YES as REAL) / cast(H.INP_YES + H.INP_NO + H.UNIDENTIFIED as REAL)) * 100, 1) as '入院率' from HOSPITALIZATION as H join PREFECTURE as P on H.PF_CODE=P.PF_CODE order by 3 desc;