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