Lines Matching refs:as

75          (SELECT max(x),y FROM t1 GROUP BY y) as b
83          (SELECT max(x),y FROM t1 GROUP BY y) as b
90     FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
91          (SELECT max(x) as r, y as s FROM t1 GROUP BY y) as b
98     FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
99          (SELECT max(x) as r, y as s, min(x)+y FROM t1 GROUP BY y) as b
131          (SELECT max(a),b FROM t2 GROUP BY b) as b
139          (SELECT max(a),b FROM t2 GROUP BY b) as b
146     FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY b) AS a,
147          (SELECT max(a) as r, b as s FROM t2 GROUP BY b) as b
154     FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
155          (SELECT max(a) as r, b as s FROM t2 GROUP BY s) as b
169        FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
170             (SELECT max(a) as r, b as s FROM t2 GROUP BY s) as b
176     SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
181     SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
186     SELECT x,y,x+y FROM (SELECT avg(a) as 'x', avg(b) as 'y' FROM t2 WHERE a=4)
191     SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
197     SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
203     SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
209     SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
215     SELECT a,b,a+b FROM (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b)
222        (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b)
229        (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b HAVING a>1)
236        (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b HAVING a>1)
377 # The following procedure compiles the SQL given as an argument and returns
406        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
417        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
426        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
435          (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
447          (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n