Lines Matching refs:sum

32   1 "SELECT a, sum(b) FROM t1 GROUP BY a HAVING a=2" {2 12}
33   2 "SELECT a, sum(b) FROM t1 GROUP BY a HAVING a=2 AND sum(b)>10" {2 12}
34   3 "SELECT a, sum(b) FROM t1 GROUP BY a HAVING sum(b)>12" {}
59   1 "SELECT a, sum(b) FROM t1 GROUP BY a HAVING a=2"
60     "SELECT a, sum(b) FROM t1 WHERE a=2 GROUP BY a"
62   2 "SELECT a, sum(b) FROM t1 GROUP BY a HAVING sum(b)>5 AND a=2"
63     "SELECT a, sum(b) FROM t1 WHERE a=2 GROUP BY a HAVING sum(b)>5"
65   3 "SELECT a, sum(b) FROM t1 GROUP BY a COLLATE binary HAVING a=2"
66     "SELECT a, sum(b) FROM t1 WHERE a=2 GROUP BY a COLLATE binary"
68   5 "SELECT a, sum(b) FROM t1 GROUP BY a COLLATE binary HAVING 1"
69     "SELECT a, sum(b) FROM t1 WHERE 1 GROUP BY a COLLATE binary"
82   8 "SELECT a, sum(b) FROM t1 GROUP BY a||b HAVING substr(a||b, 1, 1)='a'"
83     "SELECT a, sum(b) FROM t1 WHERE substr(a||b, 1, 1)='a' GROUP BY a||b"
93     SELECT a AS x, sum(b) AS y FROM t1 
99     SELECT a AS x, sum(b) AS y FROM t1 
114   1 "SELECT a, sum(b) FROM t1 GROUP BY a COLLATE nocase HAVING a=2"
115     "SELECT a, sum(b) FROM t1 WHERE a=2 GROUP BY a COLLATE nocase"
117   2 "SELECT a, sum(b) FROM t1 GROUP BY a HAVING randomblob(a)<X'88'"
118     "SELECT a, sum(b) FROM t1 WHERE randomblob(a)<X'88' GROUP BY a"
146   SELECT a, sum(b) FROM t3 GROUP BY a HAVING nondeter(a)
154   SELECT a, sum(b) FROM t3 WHERE nondeter(a) GROUP BY a