Lines Matching refs:GROUP
69 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
70 (SELECT max(x),y FROM t1 GROUP BY y) as b
77 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
78 (SELECT max(x),y FROM t1 GROUP BY y) as b
85 FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
86 (SELECT max(x) as r, y as s FROM t1 GROUP BY y) as b
93 FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
94 (SELECT max(x) as r, y as s, min(x)+y FROM t1 GROUP BY y) as b
125 FROM (SELECT count(*),b FROM t2 GROUP BY b) AS a,
126 (SELECT max(a),b FROM t2 GROUP BY b) as b
133 FROM (SELECT count(*),b FROM t2 GROUP BY b) AS a,
134 (SELECT max(a),b FROM t2 GROUP BY b) as b
141 FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY b) AS a,
142 (SELECT max(a) as r, b as s FROM t2 GROUP BY b) as b
149 FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
150 (SELECT max(a) as r, b as s FROM t2 GROUP BY s) as b
164 FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
165 (SELECT max(a) as r, b as s FROM t2 GROUP BY s) as b
211 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b)
218 (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b)
225 (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b HAVING a>1)
232 (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b HAVING a>1)
238 SELECT [count(*)],y FROM (SELECT count(*), y FROM t1 GROUP BY y)
244 SELECT [count(*)],y FROM (SELECT count(*), y FROM t1 GROUP BY y)