Lines Matching full:order

37   execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
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;
131   execsql {SELECT log, count(*) FROM t1 GROUP BY log HAVING log>=4 ORDER BY log}
138     ORDER BY log
146     ORDER BY max(n)
154     ORDER BY max(n)
162     ORDER BY max(n)
170     ORDER BY max(n+log*2), avg(n)
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;
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;