Lines Matching refs:y

22   CREATE TABLE t1(x int, y int);
34   execsql {SELECT DISTINCT y FROM t1 ORDER BY y}
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
60 } {1 {no such column: temp.t1.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
171     CREATE TABLE t3(x,y);
175     SELECT count(x), y FROM t3 GROUP BY y ORDER BY 1
180     CREATE TABLE t4(x,y,z);
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;