Lines Matching refs:log

24     CREATE TABLE t1(n int, log int);
34   execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
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}
55   execsql {SELECT log, count(*) FROM t1 GROUP BY log ORDER BY log}
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}
74     SELECT log*2+1 as x, count(*) FROM t1 GROUP BY x ORDER BY x
79     SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY y, x
84     SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY 10-(x+y)
89 #    SELECT log, count(*) FROM t1 GROUP BY 'x' ORDER BY log;
94     SELECT log, count(*) FROM t1 GROUP BY 0 ORDER BY log;
99     SELECT log, count(*) FROM t1 GROUP BY 3 ORDER BY log;
104     SELECT log, count(*) FROM t1 GROUP BY 1 ORDER BY log;
111     SELECT log, count(*) FROM t1 GROUP BY ORDER BY log;
116     SELECT log, count(*) FROM t1 GROUP BY;
125   SELECT log, count(*) FROM t1 HAVING log>=4
128   SELECT count(*) FROM t1 HAVING log>=4
131   SELECT count(*) FROM t1 HAVING log!=400
137   execsql {SELECT log, count(*) FROM t1 GROUP BY log HAVING log>=4 ORDER BY log}
141     SELECT log, count(*) FROM t1 
142     GROUP BY log 
144     ORDER BY log
149     SELECT log, count(*) FROM t1 
150     GROUP BY log 
157     SELECT log AS x, count(*) AS y FROM t1 
165     SELECT log AS x FROM t1 
174     SELECT log, count(*), avg(n), max(n+log*2) FROM t1 
175     GROUP BY log 
176     ORDER BY max(n+log*2)+0, avg(n)+0
181     SELECT log, count(*), avg(n), max(n+log*2) FROM t1 
182     GROUP BY log 
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;
212     CREATE INDEX i1 ON t1(log);
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;