Lines Matching refs:q

89     SELECT q, p, r
90     FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
92     WHERE q=s ORDER BY s
97     SELECT q, p, r, b.[min(x)+y]
98     FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
100     WHERE q=s ORDER BY s
145     SELECT q, p, r
146     FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY b) AS a,
148     WHERE q=s ORDER BY s
153     SELECT a.q, a.p, b.r
154     FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
156     WHERE a.q=b.s ORDER BY a.q
168       (SELECT a.q, a.p, b.r
169        FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
171        WHERE a.q=b.s ORDER BY a.q)
285       (SELECT x AS 'b' FROM t1 WHERE y=4) AS 'q'
392     CREATE TABLE t3(p,q);
395     CREATE TABLE t4(q,r);
404     SELECT y, p, q, r FROM
406        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
415     SELECT y, p, q, r FROM
417        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
424     SELECT DISTINCT y, p, q, r FROM
426        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
433       (SELECT y, p, q, r FROM
435          (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
437       (SELECT r AS z FROM t4 WHERE q=11) AS f
445       (SELECT y, p, q, r FROM
447          (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
449       (SELECT r AS z FROM t4 WHERE q=11) AS f