Lines Matching full:as
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
172 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
177 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
182 SELECT x,y,x+y FROM (SELECT avg(a) as 'x', avg(b) as 'y' FROM t2 WHERE a=4)
187 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
193 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
199 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
205 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
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)
252 (SELECT x AS 'a', y AS 'b', x+y AS 'c' FROM t1 WHERE y=4)
280 (SELECT x+3 AS 'a', x FROM t1 WHERE y=3) AS 'p',
281 (SELECT x AS 'b' FROM t1 WHERE y=4) AS 'q'
289 (SELECT x+3 AS 'a', x FROM t1 WHERE y=3),
290 (SELECT x AS 'b' FROM t1 WHERE y=4)
307 SELECT x AS 'a' FROM t1 UNION ALL SELECT x+10 AS 'a' FROM t1
314 SELECT x AS 'a' FROM t1 UNION ALL SELECT x+1 AS 'a' FROM t1
321 SELECT x AS 'a' FROM t1 UNION SELECT x+1 AS 'a' FROM t1
328 SELECT x AS 'a' FROM t1 INTERSECT SELECT x+1 AS 'a' FROM t1
335 SELECT x AS 'a' FROM t1 EXCEPT SELECT x*2 AS 'a' FROM t1
349 SELECT c,b,a,* FROM (SELECT 1 AS 'a', 2 AS 'b', 'abc' AS 'c')
354 SELECT c,b,a,* FROM (SELECT 1 AS 'a', 2 AS 'b', 'abc' AS 'c' WHERE 0)
359 SELECT c,b,a,* FROM (SELECT 1 AS 'a', 2 AS 'b', 'abc' AS 'c' WHERE 1)
363 # The following procedure compiles the SQL given as an argument and returns
391 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
392 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
399 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
400 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
407 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
408 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
416 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
417 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
418 WHERE y=p) AS e,
419 (SELECT r AS z FROM t4 WHERE q=11) AS f
427 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
428 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
429 WHERE y=p) AS e,
430 (SELECT r AS z FROM t4 WHERE q=11) AS f