select nom, prenom,intitule, credits from etudiant e
right join inscription i on e.idEtu=i.idEtu
right join cours c on c.idcours=i.idCours;
 
-- Question 4
select * from etudiant cross join cours ;
 
-- question 5
select nom, prenom, note from etudiant join inscription on etudiant.idetu=inscription.idetu;
 
-- question 6
 
select nom,prenom from etudiant e 
left join inscription i on e.idetu=i.idetu
where i.idCours is null;
 
-- question 7
select intitule from cours 
left join inscription on
cours.idcours = inscription.idcours 
where inscription.idetu is null;
 
-- question 8
select et.nom,et.prenom,es.nom from etudiant et 
join inscription i on i.idetu=et.idetu
join cours c on i.idcours=c.idcours
join enseigne ens on ens.idcours=c.idcours
join enseignant es on es.idens=ens.idens;
 
 
-- question 8 bis with only where clause
select et.nom,et.prenom,es.nom from etudiant et ,
inscription i ,cours c,enseigne ens, enseignant es
where i.idetu=et.idetu
AND i.idcours=c.idcours
AND ens.idcours=c.idcours
AND es.idens=ens.idens;
 
 
-- question 9
 
select en.nom,en.specialite from enseignant en 
left join enseigne eg on en.idens=eg.idens
where eg.idcours is null;
 
-- question 11
select nom, prenom,intitule, credits from etudiant e
 join inscription i on e.idEtu=i.idEtu
 join cours c on c.idcours=i.idCours
where c.intitule='BD';
-- QUESTION 13
 
SELECT NOM, INTITULE FROM ENSEIGNANT ES
JOIN ENSEIGNE E ON E.IDENS=ES.IDENS
JOIN COURS C ON C.IDCOURS= E.IDCOURS;
 
-- QUESTION 14
SELECT NOM, INTITULE FROM ENSEIGNANT ES
LEFT JOIN ENSEIGNE E ON E.IDENS=ES.IDENS
LEFT JOIN COURS C ON C.IDCOURS= E.IDCOURS
 WHERE E.IDCOURS IS NULL;
 -- QUESTION 15
 -- SAME AS QUESTION 8
 

c2VsZWN0IG5vbSwgcHJlbm9tLGludGl0dWxlLCBjcmVkaXRzIGZyb20gZXR1ZGlhbnQgZQpyaWdodCBqb2luIGluc2NyaXB0aW9uIGkgb24gZS5pZEV0dT1pLmlkRXR1CnJpZ2h0IGpvaW4gY291cnMgYyBvbiBjLmlkY291cnM9aS5pZENvdXJzOwogCi0tIFF1ZXN0aW9uIDQKc2VsZWN0ICogZnJvbSBldHVkaWFudCBjcm9zcyBqb2luIGNvdXJzIDsKCi0tIHF1ZXN0aW9uIDUKc2VsZWN0IG5vbSwgcHJlbm9tLCBub3RlIGZyb20gZXR1ZGlhbnQgam9pbiBpbnNjcmlwdGlvbiBvbiBldHVkaWFudC5pZGV0dT1pbnNjcmlwdGlvbi5pZGV0dTsKCi0tIHF1ZXN0aW9uIDYKCnNlbGVjdCBub20scHJlbm9tIGZyb20gZXR1ZGlhbnQgZSAKbGVmdCBqb2luIGluc2NyaXB0aW9uIGkgb24gZS5pZGV0dT1pLmlkZXR1CndoZXJlIGkuaWRDb3VycyBpcyBudWxsOwoKLS0gcXVlc3Rpb24gNwpzZWxlY3QgaW50aXR1bGUgZnJvbSBjb3VycyAKbGVmdCBqb2luIGluc2NyaXB0aW9uIG9uCmNvdXJzLmlkY291cnMgPSBpbnNjcmlwdGlvbi5pZGNvdXJzIAp3aGVyZSBpbnNjcmlwdGlvbi5pZGV0dSBpcyBudWxsOwoKLS0gcXVlc3Rpb24gOApzZWxlY3QgZXQubm9tLGV0LnByZW5vbSxlcy5ub20gZnJvbSBldHVkaWFudCBldCAKam9pbiBpbnNjcmlwdGlvbiBpIG9uIGkuaWRldHU9ZXQuaWRldHUKam9pbiBjb3VycyBjIG9uIGkuaWRjb3Vycz1jLmlkY291cnMKam9pbiBlbnNlaWduZSBlbnMgb24gZW5zLmlkY291cnM9Yy5pZGNvdXJzCmpvaW4gZW5zZWlnbmFudCBlcyBvbiBlcy5pZGVucz1lbnMuaWRlbnM7CgoKLS0gcXVlc3Rpb24gOCBiaXMgd2l0aCBvbmx5IHdoZXJlIGNsYXVzZQpzZWxlY3QgZXQubm9tLGV0LnByZW5vbSxlcy5ub20gZnJvbSBldHVkaWFudCBldCAsCmluc2NyaXB0aW9uIGkgLGNvdXJzIGMsZW5zZWlnbmUgZW5zLCBlbnNlaWduYW50IGVzCndoZXJlIGkuaWRldHU9ZXQuaWRldHUKQU5EIGkuaWRjb3Vycz1jLmlkY291cnMKQU5EIGVucy5pZGNvdXJzPWMuaWRjb3VycwpBTkQgZXMuaWRlbnM9ZW5zLmlkZW5zOwoKCi0tIHF1ZXN0aW9uIDkKCnNlbGVjdCBlbi5ub20sZW4uc3BlY2lhbGl0ZSBmcm9tIGVuc2VpZ25hbnQgZW4gCmxlZnQgam9pbiBlbnNlaWduZSBlZyBvbiBlbi5pZGVucz1lZy5pZGVucwp3aGVyZSBlZy5pZGNvdXJzIGlzIG51bGw7CgotLSBxdWVzdGlvbiAxMQpzZWxlY3Qgbm9tLCBwcmVub20saW50aXR1bGUsIGNyZWRpdHMgZnJvbSBldHVkaWFudCBlCiBqb2luIGluc2NyaXB0aW9uIGkgb24gZS5pZEV0dT1pLmlkRXR1CiBqb2luIGNvdXJzIGMgb24gYy5pZGNvdXJzPWkuaWRDb3Vycwp3aGVyZSBjLmludGl0dWxlPSdCRCc7Ci0tIFFVRVNUSU9OIDEzCgpTRUxFQ1QgTk9NLCBJTlRJVFVMRSBGUk9NIEVOU0VJR05BTlQgRVMKSk9JTiBFTlNFSUdORSBFIE9OIEUuSURFTlM9RVMuSURFTlMKSk9JTiBDT1VSUyBDIE9OIEMuSURDT1VSUz0gRS5JRENPVVJTOwoKLS0gUVVFU1RJT04gMTQKU0VMRUNUIE5PTSwgSU5USVRVTEUgRlJPTSBFTlNFSUdOQU5UIEVTCkxFRlQgSk9JTiBFTlNFSUdORSBFIE9OIEUuSURFTlM9RVMuSURFTlMKTEVGVCBKT0lOIENPVVJTIEMgT04gQy5JRENPVVJTPSBFLklEQ09VUlMKIFdIRVJFIEUuSURDT1VSUyBJUyBOVUxMOwogLS0gUVVFU1RJT04gMTUKIC0tIFNBTUUgQVMgUVVFU1RJT04gOAo=