Lines Matching refs:count

40   execsql {SELECT count(*) FROM t1}
55   execsql {SELECT log, count(*) FROM t1 GROUP BY log ORDER BY log}
74     SELECT log*2+1 as x, count(*) FROM t1 GROUP BY x ORDER BY x
79     SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY y, x
84     SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY 10-(x+y)
89 #    SELECT log, count(*) FROM t1 GROUP BY 'x' ORDER BY log;
94     SELECT log, count(*) FROM t1 GROUP BY 0 ORDER BY log;
99     SELECT log, count(*) FROM t1 GROUP BY 3 ORDER BY log;
104     SELECT log, count(*) FROM t1 GROUP BY 1 ORDER BY log;
111     SELECT log, count(*) FROM t1 GROUP BY ORDER BY log;
116     SELECT log, count(*) FROM t1 GROUP BY;
125   SELECT log, count(*) FROM t1 HAVING log>=4
128   SELECT count(*) FROM t1 HAVING log>=4
131   SELECT count(*) FROM t1 HAVING log!=400
137   execsql {SELECT log, count(*) FROM t1 GROUP BY log HAVING log>=4 ORDER BY log}
141     SELECT log, count(*) FROM t1 
143     HAVING count(*)>=4 
149     SELECT log, count(*) FROM t1 
151     HAVING count(*)>=4 
157     SELECT log AS x, count(*) AS y FROM t1 
167     HAVING count(*)>=4 
174     SELECT log, count(*), avg(n), max(n+log*2) FROM t1 
181     SELECT log, count(*), avg(n), max(n+log*2) FROM t1 
383   SELECT count(x), m FROM t1 LEFT JOIN (SELECT x, 59 AS m FROM t2) GROUP BY a;
387   SELECT count(x), m FROM t1 LEFT JOIN (SELECT x, 59 AS m FROM t2) GROUP BY a;
395   SELECT count(x), m FROM t1 LEFT JOIN (SELECT x, 59 AS m FROM t2) GROUP BY a;
403   SELECT count(x), m FROM t1 LEFT JOIN (SELECT x, 59 AS m FROM t2) GROUP BY a;
411   SELECT count(x), m FROM t1 LEFT JOIN (SELECT x, 59 AS m FROM t2) GROUP BY a;