mysql查数据问题

Question

查出siteid相同的uv,pv,ip的总数
返回结果 [{'siteid':731,'uv':1,'pv':27,'ip':5},{‘siteid’:495,'uv':5,'pv':36,'ip':3}],
如果还能在加一个排序就好了，按uv，pv，ip任意排序

Answer 1

SELECT siteid, sum(uv) AS uv, sum(pv) AS pv, sum(ip) AS ip FROM table_name GROUP BY siteid ORDER BY uv;

Answer 2

group by