Lines Matching refs:y
26 CREATE TABLE t1(x, y);
48 SELECT DISTINCT y FROM t1 ORDER BY y;
53 execsql2 {SELECT * FROM (SELECT x, y FROM t1 WHERE x<2)}
54 } {x 1 y 1}
56 execsql {SELECT count(*) FROM (SELECT y FROM t1)}
59 execsql {SELECT count(*) FROM (SELECT DISTINCT y FROM t1)}
62 execsql {SELECT count(*) FROM (SELECT DISTINCT * FROM (SELECT y FROM t1))}
65 execsql {SELECT count(*) FROM (SELECT * FROM (SELECT DISTINCT y FROM t1))}
71 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
72 (SELECT max(x),y FROM t1 GROUP BY y) as b
73 WHERE a.y=b.y ORDER BY a.y
78 SELECT a.y, a.[count(*)], [max(x)], [count(*)]
79 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
80 (SELECT max(x),y FROM t1 GROUP BY y) as b
81 WHERE a.y=b.y ORDER BY a.y
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
94 SELECT q, p, r, b.[min(x)+y]
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
161 } {x 3 y 2}
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)
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)
247 ORDER BY y
254 (SELECT x AS 'a', y AS 'b', x+y AS 'c' FROM t1 WHERE y=4)
260 SELECT y FROM (SELECT DISTINCT y FROM t1) WHERE y<5 ORDER BY y
265 SELECT DISTINCT y FROM (SELECT y FROM t1) WHERE y<5 ORDER BY y
270 SELECT avg(y) FROM (SELECT DISTINCT y FROM t1) WHERE y<5 ORDER BY y
275 SELECT avg(y) FROM (SELECT DISTINCT y FROM t1 WHERE y<5) ORDER BY y
282 (SELECT x+3 AS 'a', x FROM t1 WHERE y=3) AS 'p',
283 (SELECT x AS 'b' FROM t1 WHERE y=4) AS 'q'
291 (SELECT x+3 AS 'a', x FROM t1 WHERE y=3),
292 (SELECT x AS 'b' FROM t1 WHERE y=4)
392 SELECT y, p, q, r FROM
393 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
395 WHERE y=p
400 SELECT y, p, q, r FROM
401 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
403 WHERE y=p
408 SELECT DISTINCT y, p, q, r FROM
409 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
411 WHERE y=p
417 (SELECT y, p, q, r FROM
418 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
420 WHERE y=p) AS e,
428 (SELECT y, p, q, r FROM
429 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
431 WHERE y=p) AS e,