Lines Matching refs:n

24     CREATE TABLE t1(n int, log int);
44     SELECT min(n),min(log),max(n),max(log),sum(n),sum(log),avg(n),avg(log)
49   execsql {SELECT max(n)/avg(n), max(log)/avg(log) FROM t1}
58   execsql {SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log}
61   execsql {SELECT log, avg(n) FROM t1 GROUP BY log ORDER BY log}
64   execsql {SELECT log, avg(n)+1 FROM t1 GROUP BY log ORDER BY log}
67   execsql {SELECT log, avg(n)-min(n) FROM t1 GROUP BY log ORDER BY log}
70   execsql {SELECT log*2+1, avg(n)-min(n) FROM t1 GROUP BY log ORDER BY log}
152     ORDER BY max(n)+0
160     ORDER BY max(n)+0
168     ORDER BY max(n)+0
174     SELECT log, count(*), avg(n), max(n+log*2) FROM t1 
176     ORDER BY max(n+log*2)+0, avg(n)+0
181     SELECT log, count(*), avg(n), max(n+log*2) FROM t1 
183     ORDER BY max(n+log*2)+0, min(log,avg(n))+0
192     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log;
197     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log DESC;
202     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1;
207     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1 DESC;
213     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log;
218     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log DESC;
223     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1;
228     SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1 DESC;
430   SELECT group_concat(x), m, n FROM t1 
431     LEFT JOIN (SELECT x, 59 AS m, 60 AS n FROM t2) GROUP BY a;