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
9 ---------------------------------------------------------
10 t1.f1 t1.f2 t1.f3 t1.f4
11 ---------------------------------------------------------
14 3 60 Kisor Ambli Developer
17 4 90 Bhahmananda MKTING
20 Statement Executed
: Rows Affected
= 1
21 Statement Executed
: Rows Affected
= 1
22 Statement Executed
: Rows Affected
= 1
23 Statement Executed
: Rows Affected
= 1
24 Statement Executed
: Rows Affected
= 1
25 Statement Executed
: Rows Affected
= 1
26 Statement Executed
: Rows Affected
= 1
27 echo SELECT
* from t1
;
28 ---------------------------------------------------------
29 t1.f1 t1.f2 t1.f3 t1.f4
30 ---------------------------------------------------------
33 3 60 Kisor Ambli Developer
36 4 90 Bhahmananda MKTING
38 echo select t1.f1
,t1.f2
,count
(t1.f4
),count
(t2.f3
) from t1
,t2 group by t1.f1
,t1.f2
;
39 ---------------------------------------------------------
40 t1.f1 t1.f2 COUNT
(t1.f4
) COUNT
(t2.f3
)
41 ---------------------------------------------------------
49 echo select t1.f1
,t1.f2
,count
(t1.f4
),count
(t2.f3
) from t1
,t2 group by t1.f1
,t1.f2 having count
(t1.f4
)<6 and count
(t2.f3
) >=7;
50 ---------------------------------------------------------
51 t1.f1 t1.f2 COUNT
(t1.f4
) COUNT
(t2.f3
)
52 ---------------------------------------------------------
56 echo select t1.f1
,t1.f2
,count
(t1.f3
),count
(t2.f3
) from t1
,t2 group by t1.f1
,t1.f2 having avg
(t1.f2
)<70;
57 ---------------------------------------------------------
58 t1.f1 t1.f2 COUNT
(t1.f3
) COUNT
(t2.f3
)
59 ---------------------------------------------------------