E01="SELECT Lbsexe,AVG((CAST('01-01-2000' AS Date)-Dtnaiss)/365) AS \"Age Moyen\"\nFROM SEXE S,ETUDIANT E\nWHERE E.Cdsexe=S.Cdsexe\nGROUP BY Lbsexe;"
E02="SELECT Nomens, Grade\nFROM ENSEIGNANT E, MATIERE M\nWHERE E.Numens=M.Numens\nAND Nomat='Histoire';"
E03="SELECT DISTINCT(Numetu), Nometu\nFROM ETUDIANT\nWHERE Numetu NOT IN\n     (SELECT Numetu FROM NOTES N, MATIERE M\n      WHERE N.Numat=M.Numat\n      AND Nomat='Sociologie');"
E04="SELECT Nomat, Coeff\nFROM MATIERE M, ENSEIGNANT E\nWHERE M.Numens=E.Numens\nAND Grade IN('PR', 'MCF');"
E05="SELECT Nometu, E.Numetu, Nomat, AVG(Note)\nFROM ETUDIANT E, NOTES N, MATIERE M\nWHERE E.Numetu=N.Numetu\nAND N.Numat=M.Numat\nGROUP BY Nometu, E.Numetu, Nomat\nORDER BY Nometu;"
E06="SELECT Nometu,(CURRENT_DATE-Dtnaiss)/365 AS Age, Cdsexe\n FROM ETUDIANT E, NOTES N, MATIERE M\nWHERE E.Numetu=N.Numetu\nAND N.Numat=M.Numat\nAND Nomat='Informatique'\nAND Note>(SELECT AVG(Note) FROM NOTES N, MATIERE M\n       WHERE N.Numat=M.Numat\n       AND Nomat='Informatique');"
E07="SELECT Nometu, E.Numetu, SUM(Note*Coeff)/SUM(Coeff) AS Moyenne\nFROM ETUDIANT E, NOTES N, MATIERE M\nWHERE E.Numetu=N.Numetu\nAND N.Numat=M.Numat\nGROUP BY Nometu, E.Numetu\nHAVING COUNT(Note)=5\nORDER BY Nometu;"
E08="SELECT Nomens, Grade, Ancien\nFROM ENSEIGNANT E, MATIERE M\nWHERE E.Numens=M.Numens\nGROUP BY Nomens, Grade, Ancien\nHAVING COUNT(Nomens)>1;"
E09="SELECT Lbsexe, COUNT(Lbsexe)\nFROM SEXE S, ETUDIANT E\nWHERE S.Cdsexe=E.Cdsexe\nAND E.Numetu IN\n    (SELECT E.Numetu FROM ETUDIANT E, NOTES N, MATIERE M\n    WHERE E.Numetu=N.Numetu\n    AND N.Numat=M.Numat\n    GROUP BY E.Numetu\n    HAVING (SUM(Note*Coeff)/SUM(Coeff)>=10 AND COUNT(Nomat)=5))\nGROUP BY Lbsexe;"
E10="SELECT Nometu, E.Numetu, Cdsexe\nFROM ETUDIANT E, NOTES N, MATIERE M\nWHERE E.Numetu=N.Numetu\nAND N.Numat=M.Numat\nAND Nomat='Informatique'\nAND Note > ALL\n   (SELECT Note FROM NOTES N, MATIERE M\n    WHERE N.Numat=M.Numat\n    AND Nomat='Mathématiques'\n    AND N.Numetu=E.Numetu);"
E11="SELECT E1.Nometu,E2.Nometu\nFROM ETUDIANT E1, ETUDIANT E2\nWHERE E1.CdSexe='H'\nAND E2.CdSexe='F'\nAND (E1.Dtnaiss-E2.Dtnaiss) BETWEEN -180 AND 180;"
E12="SELECT E.Numetu, Nometu, Nomat\nFROM ETUDIANT E\nLEFT OUTER JOIN NOTES N\nON E.Numetu=N.Numetu\nLEFT OUTER JOIN Matiere M\nON N.Numat=M.Numat OR N.Numat IS NULL\nWHERE Note IS NULL;"
E13="SELECT Nomens, Nomat, Avg(note)\nFROM ENSEIGNANT E, MATIERE M, NOTES N\nWHERE E.Numens=M.Numens\nAND M.Numat=N.Numat\nGROUP BY Nomens, Nomat\nHAVING Avg(note)< 10;"
E14="SELECT Nomat, Nometu, Note\nFROM MATIERE M, NOTES N, ETUDIANT E\nWHERE N.Numat=M.Numat\nAND E.Numetu=N.Numetu\nAND Note=(SELECT Max(Note) FROM NOTES E1\n          WHERE E1.Numat=M.Numat);"
E15="SELECT Lbsexe, Sum(Note)/Count(Note) AS Moyenne\nFROM SEXE S, ETUDIANT E, NOTES N, MATIERE M, ENSEIGNANT G\nWHERE S.Cdsexe=E.Cdsexe\nAND E.Numetu=N.Numetu\nAND N.Numat=M.Numat\nAND M.Numens=G.Numens\nAND Nomens='Boyer, Julie'\nGROUP BY Lbsexe;"
function Num()
  {for (i=0; i<15; i++) 
      {if (document.forms[0].choix[i].checked) {break;}} 
   switch (i)
	{case 0:document.forms[1].Nreq.value="E01"; break;
	 case 1:document.forms[1].Nreq.value="E02"; break;
	 case 2:document.forms[1].Nreq.value="E03"; break;
	 case 3:document.forms[1].Nreq.value="E04"; break;
	 case 4:document.forms[1].Nreq.value="E05"; break;
	 case 5:document.forms[1].Nreq.value="E06"; break;
	 case 6:document.forms[1].Nreq.value="E07"; break;
	 case 7:document.forms[1].Nreq.value="E08"; break;
	 case 8:document.forms[1].Nreq.value="E09"; break;
	 case 9:document.forms[1].Nreq.value="E10"; break;
	 case 10:document.forms[1].Nreq.value="E11"; break;
	 case 11:document.forms[1].Nreq.value="E12"; break;
	 case 12:document.forms[1].Nreq.value="E13"; break;
	 case 13:document.forms[1].Nreq.value="E14"; break;
	 case 14:document.forms[1].Nreq.value="E15"; break;
	}
  }
function reponseE()
  {if (document.forms[1].Nreq.value=="E01") {document.forms[1].ReqSQL.value=E01;}
   if (document.forms[1].Nreq.value=="E02") {document.forms[1].ReqSQL.value=E02;}
   if (document.forms[1].Nreq.value=="E03") {document.forms[1].ReqSQL.value=E03;}
   if (document.forms[1].Nreq.value=="E04") {document.forms[1].ReqSQL.value=E04;}
   if (document.forms[1].Nreq.value=="E05") {document.forms[1].ReqSQL.value=E05;}
   if (document.forms[1].Nreq.value=="E06") {document.forms[1].ReqSQL.value=E06;}
   if (document.forms[1].Nreq.value=="E07") {document.forms[1].ReqSQL.value=E07;}
   if (document.forms[1].Nreq.value=="E08") {document.forms[1].ReqSQL.value=E08;}
   if (document.forms[1].Nreq.value=="E09") {document.forms[1].ReqSQL.value=E09;}
   if (document.forms[1].Nreq.value=="E10") {document.forms[1].ReqSQL.value=E10;}
   if (document.forms[1].Nreq.value=="E11") {document.forms[1].ReqSQL.value=E11;}
   if (document.forms[1].Nreq.value=="E12") {document.forms[1].ReqSQL.value=E12;}
   if (document.forms[1].Nreq.value=="E13") {document.forms[1].ReqSQL.value=E13;}
   if (document.forms[1].Nreq.value=="E14") {document.forms[1].ReqSQL.value=E14;}
   if (document.forms[1].Nreq.value=="E15") {document.forms[1].ReqSQL.value=E15;}
  }
function raz()
  {document.forms[1].ReqSQL.value="";}
function test()
  {if (document.forms[1].Nreq.value=="") 
    {alert("Choisissez une question"); window.focus();}
  }