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 Statement Executed
: Rows Affected
= 1
12 echo Select f1
,f5 from T1 order by f1
;
13 ---------------------------------------------------------
15 ---------------------------------------------------------
27 SELECT T1.f1
,AVG
(T1.f5
) FROM T1 GROUP BY T1.f1
;
29 100 3666.6666666666665
34 SELECT f1
,AVG
(f5
) FROM T1 GROUP BY f1 HAVING AVG
(f5
)>5000;
38 SELECT f1
,AVG
(f5
) FROM T1 WHERE f1
>200 GROUP BY f1
;
43 SELECT f1
,AVG
(f5
) FROM T1 WHERE f1
> 100 GROUP BY f1 HAVING AVG
(f5
)>5000;
44 T1.f1 T1.f2 AVG
(T1.f5
)