Lines Matching refs:GROUP

71     FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
72          (SELECT max(x),y FROM t1 GROUP BY y) as b
79     FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
80          (SELECT max(x),y FROM t1 GROUP BY y) as b
87     FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
88          (SELECT max(x) as r, y as s FROM t1 GROUP BY y) as b
95     FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
96          (SELECT max(x) as r, y as s, min(x)+y FROM t1 GROUP BY y) as b
127     FROM (SELECT count(*),b FROM t2 GROUP BY b) AS a,
128          (SELECT max(a),b FROM t2 GROUP BY b) as b
135     FROM (SELECT count(*),b FROM t2 GROUP BY b) AS a,
136          (SELECT max(a),b FROM t2 GROUP BY b) as b
143     FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY b) AS a,
144          (SELECT max(a) as r, b as s FROM t2 GROUP BY b) as b
151     FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
152          (SELECT max(a) as r, b as s FROM t2 GROUP BY s) as b
166        FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
167             (SELECT max(a) as r, b as s FROM t2 GROUP BY s) as b
213     SELECT a,b,a+b FROM (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b)
220        (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b)
227        (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b HAVING a>1)
234        (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b HAVING a>1)
240     SELECT [count(*)],y FROM (SELECT count(*), y FROM t1 GROUP BY y)
246     SELECT [count(*)],y FROM (SELECT count(*), y FROM t1 GROUP BY y)