select PF_CODE as 都道府県コード, PF_NAME as 都道府県名, rate as 入院率 from PREFECTURE left outer join (select PF_CODE as target, ROUND(100.0 * INP_YES / (INP_YES + INP_NO + UNIDENTIFIED), 1) as rate from HOSPITALIZATION) on PF_CODE = target where rate is not null order by rate desc, abs(PF_CODE) asc;