4 SELECT avg(four) AS avg_1 FROM onek;
10 SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
16 -- In 7.1, avg(float4) is computed using float8 arithmetic.
17 -- Round the result to 3 digits to avoid platform-specific results.
18 SELECT avg(b)::numeric(10,3) AS avg_107_943 FROM aggtest;
24 SELECT avg(gpa) AS avg_3_4 FROM ONLY student;
30 SELECT sum(four) AS sum_1500 FROM onek;
36 SELECT sum(a) AS sum_198 FROM aggtest;
42 SELECT sum(b) AS avg_431_773 FROM aggtest;
48 SELECT sum(gpa) AS avg_6_8 FROM ONLY student;
54 SELECT max(four) AS max_3 FROM onek;
60 SELECT max(a) AS max_100 FROM aggtest;
66 SELECT max(aggtest.b) AS max_324_78 FROM aggtest;
72 SELECT max(student.gpa) AS max_3_7 FROM student;
78 SELECT count(four) AS cnt_1000 FROM onek;
84 SELECT count(DISTINCT four) AS cnt_4 FROM onek;
90 select ten, count(*), sum(four) from onek
91 group by ten order by ten;
106 select ten, count(four), sum(DISTINCT four) from onek
107 group by ten order by ten;
122 SELECT newavg(four) AS avg_1 FROM onek;
128 SELECT newsum(four) AS sum_1500 FROM onek;
134 SELECT newcnt(four) AS cnt_1000 FROM onek;