Td1

-- REQ1
SELECT NOM, PRENOM FROM employe;

-- REQ2
SELECT NOM FROM employe WHERE DATE_EMB < '1995-01-01';

-- REQ3
SELECT e.NOM, e.PRENOM, a.ADRESSE, a.VILLE, a.CODE_POSTAL
FROM employe e JOIN adresse a ON e.CODE_EMP = a.CODE_EMP;

-- REQ4
SELECT e.NOM, e.PRENOM FROM employe e
JOIN service s ON e.SERVICE = s.CODE_SERV
WHERE s.NOM_SERV = 'Marketing';

-- REQ5
SELECT e.NOM, e.PRENOM, s.NOM_SERV FROM employe e
JOIN service s ON e.SERVICE = s.CODE_SERV;

-- REQ6
SELECT e.NOM, e.PRENOM, s.CODE_CHEF FROM employe e
JOIN service s ON e.SERVICE = s.CODE_SERV;

-- REQ7
SELECT s.NOM_SERV FROM service s
JOIN localite l ON s.CODE_LOC = l.CODE_LOC
WHERE l.VILLE = 'Lyon' OR l.VILLE = 'Paris';

-- REQ8
SELECT s.NOM_SERV FROM service s
JOIN employe e ON s.CODE_CHEF = e.CODE_EMP
JOIN adresse a ON e.CODE_EMP = a.CODE_EMP
WHERE a.VILLE = 'Paris';

-- REQ9
SELECT e.NOM FROM employe e
JOIN service s ON e.SERVICE = s.CODE_SERV
WHERE s.NOM_SERV = 'Marketing' AND e.SALAIRE > 3000;

-- REQ10
SELECT e.NOM FROM employe e
JOIN service s ON e.CODE_EMP = s.CODE_CHEF;