select PREFECTURE.pf_code as 都道府県コード　, PREFECTURE.pf_name as 都道府県名 , (HOSPITALIZATION.inp_yes/(HOSPITALIZATION.inp_yes + HOSPITALIZATION.INP_NO + HOSPITALIZATION.UNIDENTIFIED))*100 as 入院率
from PREFECTURE
inner join HOSPITALIZATION on PREFECTURE.pf_code = HOSPITALIZATION.pf_code
order by 入院率 desc , PREFECTURE.pf_code;