SELECT ._, [_], ._, [_]
FROM ,
WHERE _ NOT IN (SELECT _ FROM 1 WHERE 1._ = ._)
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
"" 500. : ( ), , ("" "" ) .
SELECT ._ as nom, ._ as name,'' as tip
from
where .=''
UNION
SELECT ._ as nom,
._ as name,'' as tip
from
where .<500
ORDER BY name;
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 [no_st], [fio]
FROM stud
WHERE stud.no_st IN (SELECT no_st FROM uspev WHERE (no_pr IN (SELECT uspev.no_pr FROM uspev, stud WHERE uspev.ocenka<5 AND stud.fio=" .." AND stud.no_st=uspev.no_st)) GROUP BY no_st HAVING max(ocenka)<5);
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
: , , , , .
SELECT [].[], min() AS , max() AS , avg() AS
FROM , (SELECT ._ AS _,
FROM ( inner join on [].[_]=[].[_]) inner join on [].[_]=[].[_]
GROUP BY ._,)
WHERE [].[_]=_
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) . . .
992027: , ..., , ( "").
SELECT stud.no_st, stud.fio, minimum, maximum, average
FROM stud, [SELECT stud.no_st AS no_st, min(uspev.ocenka) AS minimum, max(uspev.ocenka) AS maximum, avg(uspev.ocenka) AS average
FROM stud, uspev
WHERE stud.no_st=uspev.no_st
|
|
|
GROUP BY stud.no_st]. AS [%$##@_Alias]
WHERE average>
(SELECT avg([ocenka])
FROM uspev
WHERE no_st=992027
GROUP BY [no_st];)
AND stud.no_st=no_st;
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 [stud].[spec], [uspev].[ocenka], count([uspev].[no_st]) AS kolvo_st, count([uspev].[no_pr]) AS kolvo_pr
FROM stud, uspev
WHERE [stud].[no_st]=[uspev].[no_st]
GROUP BY stud.spec, uspev.ocenka;
Stud (no_st, fio, spec, kurs, no_gr, data_rojd) ;
Prepod (no_pr, fio, kafedra, data_rojd) ;
Rukov (no_st, no_pr, ocenka, data) . . .
, , . : ( ), ..., ("" "" ) ...
SELECT no_pr AS no, fio, "" AS kateg
FROM prepod
UNION SELECT no_st AS no, fio, "" AS kateg
FROM stud
WHERE no_st IN(SELECT no_st FROM rukov)
ORDER BY fio;
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) . . .
( , , Null).
SELECT stud.no_st, stud.fio, predm.naim_pr AS naim_pr, uspev.ocenka AS ocenka
FROM stud, predm, uspev
WHERE stud.no_st=uspev.no_st
AND predm.no_pr=uspev.no_pr
UNION SELECT stud.no_st, stud.fio, " " AS naim_pr, " " AS ocenka
FROM stud
WHERE stud.no_st NOT IN (SELECT DISTINCT no_st FROM uspev);
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) . . .
( , , Null).
SELECT stud.no_st, stud.fio, predm.no_pr AS nop, predm.naim_pr AS name
FROM stud, predm
WHERE
predm.kurs=stud.kurs
AND NOT EXISTS(
SELECT no_st, no_pr
FROM uspev
WHERE uspev.no_pr=predm.no_pr
AND uspev.no_st=stud.no_st)
UNION SELECT stud.no_st, stud.fio, NULL AS nop, NULL AS name
FROM stud, predm
WHERE stud.no_st NOT IN(
SELECT stud.no_st
FROM stud, predm
WHERE predm.kurs=stud.kurs
AND NOT EXISTS(
SELECT no_st, no_pr
FROM uspev
WHERE uspev.no_pr=predm.no_pr
AND uspev.no_st=stud.no_st));
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 [stud].[no_st], [stud].[fio]
FROM stud, uspev
WHERE stud.no_st=uspev.no_st AND uspev.no_pr IN (SELECT DISTINCT [uspev].[no_pr] AS no_pr FROM uspev, stud WHERE [stud].[fio]="AAA" And [stud].[no_st]=[uspev].[no_st] And [uspev].[ocenka]=5)
GROUP BY [stud].[no_st], [stud].[fio]
HAVING min(uspev.ocenka)=5 AND max(uspev.ocenka)=5;
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
, 100 . "".
SELECT ._, ._
FROM INNER JOIN ( INNER JOIN ON ._ = ._) ON ._ = ._
WHERE ((([]![___])>100) AND (([]![])=""));
II ()-
SELECT [].[_], [_]
FROM
WHERE _ IN (SELECT _ FROM , WHERE ___ > 100 AND ._ = ._ 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) . . .
, "" , "" ..
SELECT DISTINCT [stud].[no_st], [stud].[fio]
FROM stud, uspev
WHERE stud.no_st = uspev.no_st AND uspev.ocenka = 5 AND uspev.no_pr IN (SELECT uspev.no_pr FROM stud, uspev WHERE uspev.no_st = stud.no_st AND stud.fio = '' AND uspev.ocenka =5);
II
SELECT Stud.no_st, Stud.fio
FROM INNER JOIN (Stud INNER JOIN (Predm INNER JOIN Uspev ON Predm.no_pr = Uspev.no_pr) ON Stud.no_st = Uspev.no_st) ON .no_pr = Uspev.no_pr
WHERE (((Stud.fio)<>(" ..")) AND (([Uspev]![ocenka])=""));
SELECT Uspev.no_st, Uspev.ocenka, Uspev.no_pr
FROM Stud INNER JOIN (Predm INNER JOIN Uspev ON Predm.no_pr = Uspev.no_pr) ON Stud.no_st = Uspev.no_st
WHERE ((([Stud]![fio])=" ..") AND (([Uspev]![ocenka])=""));
Stud (no_st, fio, spec, kurs, no_gr, data_rojd) ;
Prepod (no_pr, fio, kafedra, data_rojd) ;
Rukov (no_st, no_pr, ocenka, data) . . .
, , , . : ( ), ..., ("" "" ) ...
SELECT no_pr as no, fio, "" as kateg
From prepod
WHERE no_pr IN (SELECT no_pr FROM rukov)
UNION SELECT no_st as no, fio, "" as kateg
FROM stud
WHERE no_st IN (SELECT no_st FROM rukov)
ORDER BY fio;
Stud (no_st, fio, spec, kurs, no_gr, data_rojd) ;
Prepod (no_pr, fio, kafedra, data_rojd) ;
Rukov (no_st, no_pr, ocenka, data) . . .
, . : ( ), ..., ("" "" ), ... Month() .
|
|
|
SELECT no_pr AS no, fio, "Teacher" AS Kateg
FROM Prepod
WHERE Month ([Prepod]![data_rojd])=1
UNION
SELECT no_st AS no, fio, "Student" AS Kateg
FROM Stud
WHERE Month ([Stud]![data_rojd])=1
ORDER BY fio;
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) . . .
, . , , ( , , Null).
SELECT predm.no_pr, predm.naim_pr, predm.kol_chasov, predm.kafedra, predm_1.no_pr, predm_1.naim_pr
FROM predm
LEFT JOIN predm AS predm_1 ON (predm_1.kafedra=predm.kafedra) AND (predm_1.kol_chasov=predm.kol_chasov) AND (predm_1.no_pr<>predm.no_pr);
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) . . .
