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