1)
CREATE VIEW mes_infos AS
SELECT * FROM employe E
where E.nom=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
LEFT JOIN employes E ON E.num = D.directeur
where E.nom=substring_index(user(),’@’,1))
AND E.nom <> 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 E.nom=substring_index(user(),’@’,1)
group by P.projetId;