Corrigé de l'exercice 15.7

1. DELETE FROM departements WHERE nom="culture";
   
   
2. SELECT statut FROM employes WHERE nom="Némare" AND prenom="Jean";
   
   
3. UPDATE employes SET telephone="0325641353" WHERE nom="Némare" AND prenom="Jean";
   
   
4. INSERT INTO departements(id, nom, id_chef) VALUES ("recla", "réclamations", "Ném");
   
   
5. DELETE FROM departements WHERE id_chef = employes.id AND employes.nom="Haenni";
   
   
6. SELECT id_departement, SUM(salaire) FROM employes GROUP BY id_departement;
   
   
7. SELECT nom FROM employes WHERE id IN (SELECT id_chef FROM departements) ORDER BY nom;