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