SELECT ._, Count(_.__) AS _, Sum(_.__) AS , Avg(_.__) AS _, _._, _
FROM , _
WHERE (((_._) Like '*') AND ((._)=[_].[_]))
GROUP BY ._, _._, _._;
2. , 1: , , . , [-].
SELECT _, _, count(__) AS _, sum(__) AS _, avg(__) AS _, _, _
FROM , _
WHERE ._ = 1 and _._ like '*' and ._=_._
GROUP BY _, _, _, _;
3. , () ( ). , [-].
SELECT _, sum(__) AS _, count(__) AS _, _
FROM , _
WHERE ._=_._
GROUP BY _, _
HAVING sum(__) between 10000000 and 20000000 and _ like '*';
4. () ([ ], [ ], [ ]), . , , [-].
SELECT ._, _._, _.__, ._
FROM ( INNER JOIN _ ON ._=_._) INNER JOIN ON _._=._
WHERE _._ like '*' and _.__ >(select avg(__) as _ from _ where _._ like '*');
5. () ([ ], [ ], [ ], [ ]), () . , , [-].
SELECT _, _, _, __
FROM ( INNER JOIN _ ON ._=_._) INNER JOIN ON ._=_._
WHERE _._ like '*' and _.__=(select max(__) as max from _ where _._ like '*');
|
|
6. : . , . ,, . . , [-].
SELECT _, _, count(_) AS _, sum(__) AS , avg(__) AS
FROM , _
WHERE ._=_._
GROUP BY _, _;
7. : , , , . . , , [-] .
SELECT _, count(__) AS _, sum(__) AS _, avg(__) AS _, _, _
FROM ( INNER JOIN _ ON ._=_._) INNER JOIN ON ._=_._