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, 1 asc
;