2 Statement Executed
: Rows Affected
= 1
3 Statement Executed
: Rows Affected
= 1
4 Statement Executed
: Rows Affected
= 1
5 Statement Executed
: Rows Affected
= 1
6 Statement Executed
: Rows Affected
= 1
7 Statement Executed
: Rows Affected
= 1
8 Statement Executed
: Rows Affected
= 1
9 Statement Executed
: Rows Affected
= 1
10 Statement Executed
: Rows Affected
= 1
11 ---------------------------------------------------------
13 ---------------------------------------------------------
24 echo select f3
, avg
(f1
) from t1 group by f3
;
25 ---------------------------------------------------------
27 ---------------------------------------------------------
34 echo select f3
, min
(f2
) from t1 group by f3
;
35 ---------------------------------------------------------
37 ---------------------------------------------------------
44 echo select f3
, count
(f1
) from t1 group by f3
;
45 ---------------------------------------------------------
47 ---------------------------------------------------------
54 echo select f3
, sum(f2
) from t1 group by f3
;
55 ---------------------------------------------------------
57 ---------------------------------------------------------
64 echo select f3
, max
(f1
) from t1 group by f3
;
65 ---------------------------------------------------------
67 ---------------------------------------------------------
74 echo select f1
, avg
(f2
) from t1 group by f1
;
75 ---------------------------------------------------------
77 ---------------------------------------------------------
86 echo select f1
, count
(f3
) from t1 group by f1
;
87 ---------------------------------------------------------
89 ---------------------------------------------------------
98 echo select f1
, min
(f2
) from t1 group by f1
;
99 ---------------------------------------------------------
101 ---------------------------------------------------------
110 echo select f1
, sum(f3
) from t1 group by f1
;
111 ---------------------------------------------------------
113 ---------------------------------------------------------
122 echo select f1
, max
(f1
) from t1 group by f1
;
123 ---------------------------------------------------------
125 ---------------------------------------------------------
134 echo select f2
, avg
(f2
) from t1 group by f2
;
135 ---------------------------------------------------------
137 ---------------------------------------------------------
145 echo select f2
, count
(f2
) from t1 group by f2
;
146 ---------------------------------------------------------
148 ---------------------------------------------------------
156 echo select f2
, min
(f2
) from t1 group by f2
;
157 ---------------------------------------------------------
159 ---------------------------------------------------------
167 echo select f2
, sum(f2
) from t1 group by f2
;
168 ---------------------------------------------------------
170 ---------------------------------------------------------
178 echo select f2
, max
(f2
) from t1 group by f2
;
179 ---------------------------------------------------------
181 ---------------------------------------------------------