select 
pr.PF_CODE as '都道府県コード',
pr.PF_NAME as '都道府県名',
round(100.0 * INP_YES / (INP_YES + INP_NO + UNIDENTIFIED), 1) as '入院率'
from HOSPITALIZATION as ho
left join PREFECTURE as pr on ho.PF_CODE = pr.PF_CODE
order by 3 desc, 1 asc;