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