fork download
  1. -- question 1
  2. select nom, prenom,intitule, credits from etudiant e
  3. join inscription i on e.idetu=i.idetu
  4. join cours c on c.idcours=i.idcours;
  5.  
  6. -- question 2
  7. select nom, prenom,intitule, credits from etudiant e
  8. left join inscription i on e.idetu=i.idetu
  9. left join cours c on c.idcours=i.idcours;
  10. -- question 3
  11. select nom, prenom,intitule, credits from etudiant e
  12. right join inscription i on e.idetu=i.idetu
  13. right join cours c on c.idcours=i.idcours;
  14.  
  15. -- question 4
  16. select nom, prenom,intitule, credits from etudiant e cross join cours;
  17.  
  18. -- question 5
  19. select nom, prenom, note, intitule from etudiant e
  20. join inscription i on e.idetu=i.idetu
  21. join cours c on c.idcours=i.idcours;
  22. -- question 6
  23. select nom, prenom, note, intitule from etudiant e
  24. left join inscription i on e.idetu=i.idetu
  25. left join cours c on c.idcours=i.idcours
  26. where i.idcours is null;
  27.  
  28. -- question 7
  29. select nom, prenom, note, intitule from etudiant e
  30. right join inscription i on e.idetu=i.idetu
  31. right join cours c on c.idcours=i.idcours
  32. where i.idetu is null;
Success #stdin #stdout #stderr 0.01s 5320KB
stdin
Standard input is empty
stdout
Standard output is empty
stderr
Error: near line 2: no such table: etudiant
Error: near line 7: no such table: etudiant
Error: near line 11: RIGHT and FULL OUTER JOINs are not currently supported
Error: near line 16: no such table: etudiant
Error: near line 19: no such table: etudiant
Error: near line 23: no such table: etudiant
Error: near line 29: RIGHT and FULL OUTER JOINs are not currently supported