Lines Matching refs:sum

35 execsql_test 1.1 { SELECT sum(b) FROM t1 }
37 execsql_test 1.2 { SELECT sum(b) FILTER (WHERE a<10) FROM t1 }
72   SELECT sum(a+b) FILTER (WHERE a=NULL) FROM t1
77   HAVING sum(b) FILTER (WHERE b<20) > 34
82   SELECT (a%5), sum(b) FILTER (WHERE b<20) AS bbb
84   GROUP BY (a%5) HAVING sum(b) FILTER (WHERE b<20) >34
89   SELECT (a%5), sum(b) FILTER (WHERE b<20) AS bbb
91   GROUP BY (a%5) HAVING sum(b) FILTER (WHERE b<20) >34
97     sum(b) FILTER (WHERE b<20) AS bbb,
122     sum(b) FILTER (WHERE a%5=0),
123     sum(b) FILTER (WHERE a%5=1),
124     sum(b) FILTER (WHERE a%5=2),
125     sum(b) FILTER (WHERE a%5=3),
126     sum(b) FILTER (WHERE a%5=4)