Lines Matching refs:sum

29 do_execsql_test 1.1 { SELECT sum(a) FROM t1; } 45
30 do_execsql_test 1.2 { SELECT sum(a) FILTER( WHERE a<5 ) FROM t1; } 10
33   SELECT sum(a) FILTER( WHERE a>9 ),
34          sum(a) FILTER( WHERE a>8 ),
35          sum(a) FILTER( WHERE a>7 ),
36          sum(a) FILTER( WHERE a>6 ),
37          sum(a) FILTER( WHERE a>5 ),
38          sum(a) FILTER( WHERE a>4 ),
39          sum(a) FILTER( WHERE a>3 ),
40          sum(a) FILTER( WHERE a>2 ),
41          sum(a) FILTER( WHERE a>1 ),
42          sum(a) FILTER( WHERE a>0 )
64   SELECT sum(a) FILTER( WHERE a>9 ),
65          sum(a) FILTER( WHERE a>8 ),
66          sum(a) FILTER( WHERE a>7 ),
67          sum(a) FILTER( WHERE a>6 ),
68          sum(a) FILTER( WHERE a>5 ),
69          sum(a) FILTER( WHERE a>4 ),
70          sum(a) FILTER( WHERE a>3 ),
71          sum(a) FILTER( WHERE a>2 ),
72          sum(a) FILTER( WHERE a>1 ),
73          sum(a) FILTER( WHERE a>0 )
97   SELECT sum(a) FILTER (WHERE 1 - max(a) OVER () > 0) FROM t1
101   SELECT sum(a) FILTER (WHERE 1 - count(a)) FROM t1