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