--select  nom, salaire, commision, (salaire+commision) from employe where fonction='Vendeur';
--select nom, prenom from employe where fonction='Vendeur' order by (nom) desc;
--select fonction,nom from employe order by fonction,nom;
--select nom, prenom, salaire from employe where commision < (salaire/4);
--select count(*) from employe where serno=10;
--select count(*) from employe where commision is not NULL and commision >0;
--select distinct fonction from employe where commision is NULL;
--select count(distinct fonction)  from employe;
--select distinct fonction,avg(salaire) from employe;a revoir 
--select sum(salaire) from employe where SerNo exist (select Nom from service where NomS='Ventes'); a revoir
--select e.nom, s.nom from employe e, service s where  e.serno = s.serno;
--select nom, fonction, salaire from employe where salaire=(select max(salaire) from employe);
--select nom from employe where salaire>(select avg(salaire) from employe);
--select nom, prenom from employe where salaire >(select max(salaire) from employe where serno=20);
--a voir
--select nom from employe where salaire>(select max(salaire) from employe where nom='Martin');
--select nom from employe where fonction exists(select fonction from employe where nom='Martin');a revoir
--select nom from employe where chef =(select distinct chef from employe where nom='Martin');
--select nom, f
--select nom from employe where dateembauche<(select min(dateembauche) from employe where serno=10);
--select e.nom, c.nom from employe e, employe c where e.chef=c.empno;
--select distinct e.nom, e.prenom from employe e, employe c where e.serno!=c.serno; a revoir 
