select p.PF_CODE as 都道府県コード, PF_NAME as 都道府県名, IFNULL(ROUND(100.0 * INP_YES / (INP_YES+INP_NO+UNIDENTIFIED),1),0) as 入院率 from HOSPITALIZATION as h 
left outer join PREFECTURE as p on p.PF_CODE = h.PF_CODE 
order by 入院率 desc, 都道府県コード asc;