SELECT count(NEED_AUTH) FROM table where url=‘yueer’;
SELECT sum(NEED_AUTH) FROM table where url=‘yueer’;
SELECT max(NEED_AUTH) FROM table where url=‘yueer’;
SELECT min(NEED_AUTH) FROM table where url=‘yueer’;
SELECT avg(NEED_AUTH) FROM table where url=‘yueer’;
count()函数会返回0;
sum\max等函数会返回null.