--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 group by fonction;
--select sum(salaire) from employe where SerNo = (select serno from service where Nom='Ventes');
--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);
--select nom, prenom, dateembauche from employe where dateembauche>'01/01/81' and serno not in (select serno from employe where dateembauche<'01/01/81');
--select nom from employe where salaire>(select max(salaire) from employe where nom='Martin');
--select nom, prenom, fonction from employe where fonction in (select fonction from employe where nom='Martin');
--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.chef=c.empno and e.serno<>c.serno;
--select round((months_between(sysdate,dateembauche)/12),1) from employe where nom='Lapotre' ;
--select nom,prenom,round((salaire/22),2) from employe;


