2 echo create table t1
(f1 char
(10),f2 char
(10),f3 int
);
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 Statement Executed
: Rows Affected
= 1
13 Statement Executed
: Rows Affected
= 1
14 Statement Executed
: Rows Affected
= 1
15 Statement Executed
: Rows Affected
= 1
16 echo select * from t1
;
17 ---------------------------------------------------------
19 ---------------------------------------------------------
33 echo select f2
,avg
(f3
) from t1 group by f2
;
34 ---------------------------------------------------------
36 ---------------------------------------------------------
42 echo select f2
,avg
(f3
) from t1 where f3
>=3000 group by f2
;
43 ---------------------------------------------------------
45 ---------------------------------------------------------
50 echo select f2
,avg
(f3
) from t1 where f3
>=2000 group by f2 having avg
(f3
)>3000;
51 ---------------------------------------------------------
53 ---------------------------------------------------------
57 echo select f2
,avg
(f3
) from t1 where f3
>=2000 group by f2 having avg
(f3
)>3000 limit
1;
58 ---------------------------------------------------------
60 ---------------------------------------------------------
63 echo select f2
,avg
(f3
) from t1 where f3
>=2000 or f2
= 'y' group by f2 having avg
(f3
)>3000;
64 ---------------------------------------------------------
66 ---------------------------------------------------------
70 echo select f1
,f2
,avg
(f3
) from t1 where f3
>=2000 or f2
= 'y' group by f1
,f2 having avg
(f3
)>3000 ;
71 ---------------------------------------------------------
73 ---------------------------------------------------------
80 echo select f2
,f1
,avg
(f3
) from t1 where f3
>=2000 or f2
= 'y' group by f1
,f2 having avg
(f3
)>3000;
81 ---------------------------------------------------------
83 ---------------------------------------------------------
90 echo select f2
,f1
,avg
(f3
) from t1 where f3
>=2000 or f2
= 'y' group by f1
,f2 having avg
(f3
)>2000 ;
91 ---------------------------------------------------------
93 ---------------------------------------------------------
103 echo select f2
,f1
,avg
(f3
) from t1 where f3
>=2000 or f2
= 'y' group by f1
,f2 having avg
(f3
)>2000 limit
3 offset
2;
104 ---------------------------------------------------------
106 ---------------------------------------------------------