1)
CREATE VIEW mes_infos AS
SELECT * FROM employe E
where E.num=substring_index(user(),”@”,1);

2)
CREATE VIEW salaire_employe AS
SELECT E.Nom,E.salaire
FROM employe E
LEFT JOIN employeDept ED ON ED.numEmploye = E.num
where ED.deptId IN (SELECT D.deptId
FROM departement D
where D.directeur=substring_index(user(),”@”,1))
AND E.num <> substring_index(user(),”@”,1)

3) CREATE VIEW moyenne_salaire_departement AS
SELECT AVG(E.salaire),D.nom FROM employes E
LEFT JOIN employedept ED on E.Num = ED.NumEmploye
LEFT JOIN departement D on ED.DeptId = D.DeptId
group by D.DeptId;

4) CREATE VIEW nb_employe_projet AS
SELECT count(ED.NumEmploye),P.NomProjet
FROM departement D
LEFT JOIN employedept ED ON ED.deptId = D.deptId
LEFT JOIN membreprojet MP ON MP.numemploye = ED.numemploye
LEFT JOIN projet P ON P.ProjetId = MP.ProjetId
LEFT JOIN employes E ON E.Num = D.directeur
where D.num=substring_index(user(),”@”,1)
group by P.projetId;