Lines Matching refs:log

33     CREATE TABLE t1(n int, log int);
37 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
47 SELECT min(n),min(log),max(n),max(log),sum(n),sum(log),avg(n),avg(log)
52 execsql {SELECT max(n)/avg(n), max(log)/avg(log) FROM t1}
58 execsql {SELECT log, count(*) FROM t1 GROUP BY log ORDER BY log}
61 execsql {SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log}
64 execsql {SELECT log, avg(n) FROM t1 GROUP BY log ORDER BY log}
67 execsql {SELECT log, avg(n)+1 FROM t1 GROUP BY log ORDER BY log}
70 execsql {SELECT log, avg(n)-min(n) FROM t1 GROUP BY log ORDER BY log}
73 execsql {SELECT log*2+1, avg(n)-min(n) FROM t1 GROUP BY log ORDER BY log}
77 SELECT log*2+1 as x, count(*) FROM t1 GROUP BY x ORDER BY x
82 SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY y
87 SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY 10-(x+y)
92 SELECT log, count(*) FROM t1 GROUP BY 'x' ORDER BY log;
97 SELECT log, count(*) FROM t1 GROUP BY 0 ORDER BY log;
102 SELECT log, count(*) FROM t1 GROUP BY 3 ORDER BY log;
107 SELECT log, count(*) FROM t1 GROUP BY 1 ORDER BY log;
112 # SELECT log, count(*) FROM t1 GROUP BY 2 ORDER BY log;
117 # SELECT log, count(*) FROM t1 GROUP BY count(*) ORDER BY log;
124 set v [catch {execsql {SELECT log, count(*) FROM t1 HAVING log>=4}} msg]
131 execsql {SELECT log, count(*) FROM t1 GROUP BY log HAVING log>=4 ORDER BY log}
135 SELECT log, count(*) FROM t1
136 GROUP BY log
138 ORDER BY log
143 SELECT log, count(*) FROM t1
144 GROUP BY log
151 SELECT log AS x, count(*) AS y FROM t1
159 SELECT log AS x FROM t1
168 SELECT log, count(*), avg(n), max(n+log*2) FROM t1
169 GROUP BY log
170 ORDER BY max(n+log*2), avg(n)
175 SELECT log, count(*), avg(n), max(n+log*2) FROM t1
176 GROUP BY log
177 ORDER BY max(n+log*2), min(log,avg(n))
186 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log;
191 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log DESC;
196 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1;
201 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1 DESC;
206 CREATE INDEX i1 ON t1(log);
207 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log;
212 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log DESC;
217 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1;
222 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1 DESC;