select ho.PF_CODE,pf.PF_NAME,replace(cast(round(cast(inp_yes as real)/cast(inp_yes+inp_no+unidentified as real)*100,2) as varchar),'.0','') from PREFECTURE pf inner join HOSPITALIZATION ho on (ho.PF_CODE = pf.PF_CODE) order by inp_yes/inp_yes+inp_no+unidentified desc,ho.PF_CODE;