select ho.PF_CODE as 都道府県コード,pf.PF_NAME as 都道府県名 ,replace(cast(round(cast(inp_yes as real)/cast(inp_yes+inp_no+unidentified as real)*100,1) as varchar),'.0','') as 入院率 from PREFECTURE pf inner join HOSPITALIZATION ho on (ho.PF_CODE = pf.PF_CODE) order by round(cast(inp_yes as real)/cast(inp_yes+inp_no+unidentified as real),1) desc,ho.PF_CODE;