select 
    h.pf_code as 都道府県コード,
    pf_name as 都道府県名,
    round(cast(inp_yes as real)/cast((inp_yes+inp_no+unidentified) as real)*100,1) as 入院率 
from hospitalization as h 
inner join prefecture as p 
on h.pf_code =p.pf_code
order by 入院率 desc,都道府県コード;