select hospitalization.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
inner join prefecture
on HOSPITALIZATION.pf_code = PREFECTURE.pf_code
order by 入院率 desc, hospitalization.pf_code asc;