Lines Matching refs:as
72 (SELECT max(x),y FROM t1 GROUP BY y) as b
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
128 (SELECT max(a),b FROM t2 GROUP BY b) as b
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
174 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
179 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
184 SELECT x,y,x+y FROM (SELECT avg(a) as 'x', avg(b) as 'y' FROM t2 WHERE a=4)
189 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
195 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
201 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
207 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
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)
365 # The following procedure compiles the SQL given as an argument and returns
394 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
402 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
410 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
419 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
430 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n