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