Lines Matching refs:count

40   execsql {SELECT y, count(*) FROM t1 GROUP BY y ORDER BY y}
43   execsql {SELECT y, count(*) FROM t1 GROUP BY y ORDER BY count(*), y}
46   execsql {SELECT count(*), y FROM t1 GROUP BY y ORDER BY count(*), y}
53     SELECT y, count(*) FROM t1 GROUP BY z ORDER BY y
58     SELECT y, count(*) FROM t1 GROUP BY temp.t1.y ORDER BY y
63     SELECT y, count(*) FROM t1 GROUP BY z(y) ORDER BY y
69     SELECT y, count(*) FROM t1 GROUP BY y HAVING count(*)<3 ORDER BY y
75     SELECT y, count(*) FROM t1 GROUP BY y HAVING z(y)<3 ORDER BY y
81     SELECT y, count(*) FROM t1 GROUP BY y HAVING count(*)<z ORDER BY y
90     SELECT x, count(*), avg(y) FROM t1 GROUP BY x HAVING x<4 ORDER BY x
94 # Run various aggregate functions when the count is zero.
103     SELECT count(x) FROM t1 WHERE x>100
175     SELECT count(x), y FROM t3 GROUP BY y ORDER BY 1
189     SELECT max(x), count(x), y, z FROM t4 GROUP BY y, z ORDER BY 1
195     SELECT count(*), count(x) as cnt FROM t4 GROUP BY y ORDER BY cnt;
212     SELECT a, count(b) FROM t8a, t8b WHERE b=t8b.rowid GROUP BY a ORDER BY a;
217     SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
222     SELECT t8a.a, count(t8a.b) FROM t8a, t8b WHERE t8a.b=t8b.rowid
228     SELECT a, count(*) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
233     SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
238     SELECT a, count(t8a.b) FROM t8a, t8b WHERE b=t8b.rowid 
244     SELECT a, count(b) FROM t8a, t8b GROUP BY a ORDER BY 2;
249     SELECT a, count(*) FROM t8a, t8b GROUP BY a ORDER BY 2;