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