select t1.PF_CODE as '都道府県コード', t2.PF_NAME as '都道府県名', 
round( (INP_YES) * 100 / (cast(INP_YES as real) + cast(INP_NO as real) + cast(UNIDENTIFIED as real)),  1)as '入院率'
from HOSPITALIZATION t1
  left outer join PREFECTURE t2
    on t1.PF_CODE = t2.PF_CODE
order by '入院率' desc, t1.PF_CODE