1/

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