Rire
SELECT NOMELEVE, PRENELEVE, C.CODECLASSE
FROM ELEVE E, CLASSE C, APPARTENIR A
WHERE C.CODECLASSE=A.CODECLASSE
AND E.CODELEVE=A.CODELEVE
AND ANNEE='2000'
ORDER BY NOMELEVE;
2/
SELECT C.CODECLASSE, DESIGNMAT, TD, COURS
FROM CLASSE C, MATIERE M, ETUDE E
WHERE C.CODECLASSE='TSTT1'
AND M.NUMAT=E.NUMEROMAT
AND C.CODECLASSE=E.CODECLASSE
ORDER BY DESIGNMAT;
3/
SELECT C.CODECLASSE, DESIGNCLASSE, COURS
FROM CLASSE C, ETUDE E, MATIERE M
WHERE C.CODECLASSE=E.CODECLASSE
AND NUMEROMAT=NUMAT
AND DESIGNMAT='Mathématiques'
AND COURS > 2
ORDER BY COURS DESC;
4/
SELECT C.CODECLASSE, DESIGNCLASSE, FILIERE, DESIGNMAT, COURS, TD
FROM CLASSE C, MATIERE M, ETUDE E
WHERE C.CODECLASSE=E.CODECLASSE
AND NUMAT=NUMEROMAT
AND COURS>0
AND TD>0
ORDER BY COURS DESC, TD DESC;
5/
SELECT COUNT(CODELEVE)
FROM ELEVE;
6/
SELECT COUNT(CODECLASSE)
FROM APPARTENIR
WHERE ANNEE='2000';
7/
SELECT CODECLASSE,COUNT(CODELEVE)
FROM APPARTENIR
GROUP BY CODECLASSE
ORDER BY CODECLASSE;
8/
SELECT C.CODECLASSE, SUM(COURS+TD)
FROM ETUDE E, CLASSE C
WHERE E.CODECLASSE=C.CODECLASSE
GROUP BY C.CODECLASSE;
9/
SELECT NOMELEVE, PRENELEVE, SEXELEVE
FROM ELEVE E, APPARTENIR A, CLASSE C, MATIERE M, ETUDE ET
WHERE E.CODELEVE=A.CODELEVE
AND A.CODECLASSE=C.CODECLASSE
AND C.CODECLASSE=ET.CODECLASSE
AND NUMEROMAT=NUMAT
AND DESIGNMAT like 'Economie%'
AND VILLELEVE!='ETAMPES';
10/
SELECT NOMELEVE, PRENELEVE
FROM ELEVE E, APPARTENIR A
WHERE E.CODELEVE=A.CODELEVE
AND CODECLASSE LIKE 'T%'
AND SEXELEVE='M';
11/
SELECT NOMELEVE,PRENELEVE,C.CODECLASSE,DESIGNMAT, COURS
FROM ELEVE E , APPARTENIR A , CLASSE C , MATIERE M , ETUDE ET
WHERE E.CODELEVE=A.CODELEVE
AND A.CODECLASSE=C.CODECLASSE
AND C.CODECLASSE=ET.CODECLASSE
AND NUMEROMAT=NUMAT
AND COURS BETWEEN 2 AND 4
AND SEXELEVE='F';
12/
SELECT AVG(COURS)
FROM ETUDE E, CLASSE C
WHERE E.CODECLASSE=C.CODECLASSE
AND filiere='STI';
13/
SELECT NOMELEVE