select HP.PF_CODE as 都道府県コード, PF.PF_NAME as 都道府県名, round(cast(HP.INP_YES as real)/cast(HP.INP_YES+HP.INP_NO+HP.UNIDENTIFIED as real)*100,1) as 入院率
from HOSPITALIZATION as HP
inner join PREFECTURE as PF
on HP.PF_CODE = PF.PF_CODE
order by 入院率 desc, HP.PF_CODE