@creationEntreprise
@insertionEntreprise

commit;

update service set Lieu='Dijon' where Nom='Ventes';
update employe set Salaire=Salaire*1.1 where salaire < (commision*2);
update employe set commision=(select avg(commision)from employe) where dateembauche < '01/01/82' and commision is NULL;
delete from service where serno = 20;

select * from service;


--rollback;


