-- Question 3a
UPDATE DroitConge
SET NbJours = 10
SELECT *
FROM DroitConge
JOIN Employe
ON DroitConge.NumEmploye = Employe.NumEmploye
JOIN NatureConge
ON DroitConge.NumNatureConge = NatureConge.NumNatureConge
WHERE Employe.Nom = 'LHERMITTE' AND NatureConge.LibelleNat = 'Conge Annuel';


-- Question 3b

-- Question 3c

-- Question 3d