Lines Matching refs:t1
31 CREATE TABLE t1(n int, log int);
32 COPY t1 FROM 'data1.txt'
35 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
41 execsql {SELECT count(*) FROM t1}
46 FROM t1
50 execsql {SELECT max(n)/avg(n), max(log)/avg(log) FROM t1}
56 execsql {SELECT log, count(*) FROM t1 GROUP BY log ORDER BY log}
59 execsql {SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log}
62 execsql {SELECT log, avg(n) FROM t1 GROUP BY log ORDER BY log}
65 execsql {SELECT log, avg(n)+1 FROM t1 GROUP BY log ORDER BY log}
68 execsql {SELECT log, avg(n)-min(n) FROM t1 GROUP BY log ORDER BY log}
71 execsql {SELECT log*2+1, avg(n)-min(n) FROM t1 GROUP BY log ORDER BY log}
75 SELECT log*2+1 as x, count(*) FROM t1 GROUP BY x ORDER BY x
80 SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY y
85 SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY 10-(x+y)
90 SELECT log, count(*) FROM t1 GROUP BY 'x' ORDER BY log;
95 SELECT log, count(*) FROM t1 GROUP BY 0 ORDER BY log;
100 SELECT log, count(*) FROM t1 GROUP BY 3 ORDER BY log;
105 SELECT log, count(*) FROM t1 GROUP BY 1 ORDER BY log;
110 # SELECT log, count(*) FROM t1 GROUP BY 2 ORDER BY log;
115 # SELECT log, count(*) FROM t1 GROUP BY count(*) ORDER BY log;
122 set v [catch {execsql {SELECT log, count(*) FROM t1 HAVING log>=4}} msg]
129 execsql {SELECT log, count(*) FROM t1 GROUP BY log HAVING log>=4 ORDER BY log}
133 SELECT log, count(*) FROM t1
141 SELECT log, count(*) FROM t1
149 SELECT log AS x, count(*) AS y FROM t1
157 SELECT log AS x FROM t1
166 SELECT log, count(*), avg(n), max(n+log*2) FROM t1
173 SELECT log, count(*), avg(n), max(n+log*2) FROM t1
184 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log;
189 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log DESC;
194 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1;
199 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1 DESC;
204 CREATE INDEX i1 ON t1(log);
205 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log;
210 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log DESC;
215 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1;
220 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1 DESC;