Rire

Disponible uniquement sur Etudier
  • Pages : 2 (455 mots )
  • Téléchargement(s) : 0
  • Publié le : 28 mars 2011
Lire le document complet
Aperçu du document
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/

SELECTC.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/

SELECTC.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 COURSDESC, TD DESC;

5/

SELECT COUNT(CODELEVE)
FROM ELEVE;

6/

SELECT COUNT(CODECLASSE)
FROM APPARTENIR
WHERE ANNEE='2000';

7/

SELECT CODECLASSE,COUNT(CODELEVE)
FROM APPARTENIR
GROUPBY 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/

SELECTNOMELEVE,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.CODECLASSEAND 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...
tracking img