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;