Lines Matching refs:b

25   CREATE TABLE t1(a INTEGER PRIMARY KEY, b INTEGER);
37   SELECT sum(b) FROM t1
41   SELECT sum(b) FILTER (WHERE a<10) FROM t1
45   SELECT count(DISTINCT b) FROM t1
49   SELECT count(DISTINCT b) FILTER (WHERE a!=19) FROM t1
53   SELECT min(b) FILTER (WHERE a>19),
54          min(b) FILTER (WHERE a>0),
55          max(a+b) FILTER (WHERE a>19),
56          max(b+a) FILTER (WHERE a BETWEEN 10 AND 40)
61   SELECT min(b),
62          min(b),
63          max(a+b),
64          max(b+a)
72   SELECT min(b) FILTER (WHERE a>19),
73          min(b) FILTER (WHERE a>0),
74          max(a+b) FILTER (WHERE a>19),
75          max(b+a) FILTER (WHERE a BETWEEN 10 AND 40)
83   SELECT sum(a+b) FILTER (WHERE a=NULL) FROM t1
88   HAVING sum(b) FILTER (WHERE b<20) > 34
93   SELECT (a%5), sum(b) FILTER (WHERE b<20) AS bbb
95   GROUP BY (a%5) HAVING sum(b) FILTER (WHERE b<20) >34
100   SELECT (a%5), sum(b) FILTER (WHERE b<20) AS bbb
102   GROUP BY (a%5) HAVING sum(b) FILTER (WHERE b<20) >34
108     sum(b) FILTER (WHERE b<20) AS bbb,
109     count(distinct b) FILTER (WHERE b<20 OR a=13) AS ccc
116     group_concat(CAST(b AS TEXT), '_') FILTER (WHERE b%2!=0),
117     group_concat(CAST(b AS TEXT), '_') FILTER (WHERE b%2!=1),
118     count(*) FILTER (WHERE b%2!=0),
119     count(*) FILTER (WHERE b%2!=1)
127     avg(b) FILTER (WHERE b>a),
128     avg(b) FILTER (WHERE b<a)
146     sum(b) FILTER (WHERE a%5=0),
147     sum(b) FILTER (WHERE a%5=1),
148     sum(b) FILTER (WHERE a%5=2),
149     sum(b) FILTER (WHERE a%5=3),
150     sum(b) FILTER (WHERE a%5=4)