,
Select distinct Predm.no_pr, Predm.naim_pr
From Stud, Predm, Uspev
Where Stud.no_st = Uspev.no_st
And Predm.no_pr = Uspev.no_pr
And Uspev.ocenka=5
And Stud.spec=
And Stud.kurs=1
Stud (no_st, fio, spec, kurs, no_gr) ;
Predm (no_pr, naim_pr, kol_chasov, kafedra, spec, kurs) ;
Uspev (no_st, no_pr, ocenka, data_sdachi) . . .
, "" ""
SELECT [predm].[no_pr], [predm].[naim_pr]
FROM (uspev INNER JOIN predm ON [uspev].[no_pr]=[predm].[no_pr]) INNER JOIN stud ON [uspev].[no_st]=[stud].[no_st]
WHERE ([uspev].[ocenka]=4 Or [uspev].[ocenka]=5) And [stud].[kurs]=1 And [stud].[spec]="asu";
Stud (no_st, fio, spec, kurs, no_gr) ;
Predm (no_pr, naim_pr, kol_chasov, kafedra, spec, kurs) ;
Uspev (no_st, no_pr, ocenka, data_sdachi) . . .
, "" , "" ..
SELECT DISTINCT [Stud].[no_st], [Stud].[fio]
FROM Uspev, Stud
WHERE Uspev.no_pr In(Select no_pr From Uspev, Stud Where Uspev.no_st = Stud.no_st And Stud.fio =" .." And Uspev.ocenka = 5) And Uspev.no_st = Stud.no_st And Uspev.ocenka = 5 And Stud.fio <> " ..";
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
( , , Null).
Select _._, _._, ._, _.___
From (
Select ._ As _,
._ As _,
.___ As ___,
._ As _
From Left Join On
._ = ._
) As _ Left Join On
._ = _._
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
, ,
Select ._
From
Where ._ Not In (
Select ._
From
Where (Select Count(*) As _count
From
Where ._ = ._)>1)
|
|
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
500: , , , ( , , )
Select _._, ._, ____, _
From (
Select ._ As _, sum (.___ * .) As _,
Count{sum} (.___) As ____
From ,
Where ._ = ._
Group By ._) As _,
Where _._ <500
And ._ = _._
{sum, ___;
count, _, .. }
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
, 100 . , " "
SELECT _, _
FROM xb
WHERE _ IN (
SELECT _
FROM X
WHERE ___ > 100
AND _ IN (
SELECT _
FROM Y
WHERE _ IN (
SELECT _
FROM Yb
WHERE _= "")))
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
, 100 ., , , " "
SELECT _, _
FROM
WHERE _ IN (
SELECT _
FROM
WHERE ___ > 100 AND
NOT EXISTS (
SELECT *
FROM
WHERE _ IN (
SELECT _
FROM
WHERE _ = '') AND
_ NOT IN (
SELECT _
FROM
WHERE ._ = ._)))
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
: , , , ,
SELECT Kal., Pr.kol_pr, Bl.kol_bl
FROM [Select distinct _2.
from _2]. AS Kal,
[SELECT DISTINCT .,
count(t._) as kol_pr
FROM [Select distinct _2.
from _2 ]. AS ,
(SELECT Distinct _4., _4._
from _4, (Select distinct _5.
from _5) _6
where _4.=_6.)
AS t
WHERE .=t.
GROUP BY .]. AS Pr,
[SELECT Distinct _3., count(_3._) as kol_bl
|
|
from _3, _3
where _3._=_3._
group by _3.]. AS Bl
WHERE Kal.=Pr.
and Kal.=Bl.;
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
: , , ( , , Null)
SELECT distinct ._ as nm_bl,
._ as nm_pr,.___ as kol
from ,,
Where ._=._
and ._=._
union
SELECT distinct ._ as nm_bl,' ' as nm_pr,' ' as kol
from ,
Where (._ not in (Select ._
From ))
UNION
SELECT distinct ' ' as nm_bl,._ as nm_pr,' ' as kol
from ,
Where (._ not in (Select ._
From ));
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
, 100 . , , " "
SELECT ._, [_]
FROM
WHERE NOT EXISTS (
SELECT _
FROM 1
WHERE ___ > 100 AND
1._ = ._ AND
_ NOT IN (
SELECT _
FROM 1,
WHERE 1._ = ._ AND
_ = ''));
Stud (no_st, fio, spec, kurs, no_gr) ;
Predm (no_pr, naim_pr, kol_chasov, kafedra, spec, kurs) ;
Uspev (no_st, no_pr, ocenka, data_sdachi) . . .
4,7: , ..., , ( "")
SELECT [stud].[no_st], [stud].[fio], MIN([uspev].[ocenka]) AS minoc, MAX([uspev].[ocenka]) AS maxoc, AVG([uspev].[ocenka]) AS Sredn
FROM stud, uspev
WHERE stud.no_st = uspev.no_st AND stud.no_st IN (SELECT uspev.no_st FROM uspev GROUP BY uspev.no_st HAVING AVG(uspev.ocenka) >"4.7")
GROUP BY [stud].[no_st], [stud].[fio]
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
123: , , ( , , )
select ._, sum(.*.___) as
from ( inner join on ._=._) inner join on ._=._
group by ._, ._
having sum(.*.___)>
any (select sum(.*.___)
from inner join on ._=._
where ._=123
group by _)
Stud (no_st, fio, spec, kurs, no_gr) ;
Predm (no_pr, naim_pr, kol_chasov, kafedra, spec, kurs) ;
Uspev (no_st, no_pr, ocenka, data_sdachi) . . .
: , , , , ( "")
|
|
SELECT [spec], [kurs], MIN([uspev].[ocenka]) AS minocen, MAX([uspev].[ocenka]) AS maxocen, AVG([uspev].[ocenka]) AS Sredn
FROM stud, uspev
WHERE [stud].[no_st]=[uspev].[no_st]
GROUP BY [spec], [kurs];
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .