blob: 84958f66937431784793f9b0bebcf1d188ebb9e5 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
|
QUERY: SELECT avg(four) AS avg_1 FROM onek;
avg_1
-----
1
(1 row)
QUERY: SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
avg_32
------
32
(1 row)
QUERY: SELECT avg(b) AS avg_107_943 FROM aggtest;
avg_107_943
-----------
107.943
(1 row)
QUERY: SELECT avg(gpa) AS avg_3_4 FROM student;
avg_3_4
-------
3.4
(1 row)
QUERY: SELECT sum(four) AS sum_1500 FROM onek;
sum_1500
--------
1500
(1 row)
QUERY: SELECT sum(a) AS sum_198 FROM aggtest;
sum_198
-------
198
(1 row)
QUERY: SELECT sum(b) AS avg_431_773 FROM aggtest;
avg_431_773
-----------
431.773
(1 row)
QUERY: SELECT sum(gpa) AS avg_6_8 FROM student;
avg_6_8
-------
6.8
(1 row)
QUERY: SELECT max(four) AS max_3 FROM onek;
max_3
-----
3
(1 row)
QUERY: SELECT max(a) AS max_100 FROM aggtest;
max_100
-------
100
(1 row)
QUERY: SELECT max(aggtest.b) AS max_324_78 FROM aggtest;
max_324_78
----------
324.78
(1 row)
QUERY: SELECT max(student.gpa) AS max_3_7 FROM student;
max_3_7
-------
3.7
(1 row)
QUERY: SELECT count(four) AS cnt_1000 FROM onek;
cnt_1000
--------
1000
(1 row)
QUERY: SELECT newavg(four) AS avg_1 FROM onek;
avg_1
-----
1
(1 row)
QUERY: SELECT newsum(four) AS sum_1500 FROM onek;
sum_1500
--------
1500
(1 row)
QUERY: SELECT newcnt(four) AS cnt_1000 FROM onek;
cnt_1000
--------
1000
(1 row)
|
