Advertisement
Guest User

Untitled

a guest
Mar 16th, 2019
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.27 KB | None | 0 0
  1. SELECT Matricule
  2. FROM ETUDIANTS
  3. WHERE Matricule IN (SELECT Matricule
  4.                     FROM PARCOURS_HE_SESS
  5.                     WHERE AnSco=2005 AND Total > 650 AND Sess=1 AND Mention IN (SELECT Mention
  6.                                                                                 FROM MENTIONS
  7.                                                                                 WHERE Sess=2))
  8. ORDER BY Matricule;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement