Lines Matching refs:FROM

34     COPY t1 FROM 'data1.txt'
37   execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
43   execsql {SELECT count(*) FROM t1}
48     FROM t1
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 
143     SELECT log, count(*) FROM t1 
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 
175     SELECT log, count(*), avg(n), max(n+log*2) FROM t1 
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;
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;