SQL 语句 学习

SELECT user, sum(first)  as sum_first , sum(last) as sum_last from zabbix.wpsuser_data group by user;


SELECT user, count(user)  as count_user from zabbix.wpsuser_data group by user;

SELECT *  from zabbix.wpsuser_data where user=0;

SELECT user,count(user) from zabbix.wpsuser_data WHERE first BETWEEN '1481126400' AND '1481212799' group by user;