SELECT REPLACE(REPLACE(country,'市话',''),'国内长途','') AS country,SUM(cost) AS aa
FROM file201206
GROUP BY REPLACE(REPLACE(country,'市话',''),'国内长途','') order by aa
FROM file201206
GROUP BY REPLACE(REPLACE(country,'市话',''),'国内长途','') order by aa