SQL_REQUEST

/*1*/
SELECT NOM FROM VENDEURS vend, AGENCES agent WHERE vend.NUM_AGENCE = agent.AGENCE  AND QUOTA < (agent.OBJECTIF * 10/100);

/*alter apres avoir les insert*/

/*2*/

SELECT DISTINCT AGENCE, VILLE,REGION,OBJECTIF  FROM AGENCES agent, VENDEURS vent WHERE NUM_AGENCE = agent.AGENCE AND OBJECTIF > QUOTA


/*3*/
SELECT * FROM VENDEURS vend, AGENCES agent WHERE vend.NUM_AGENCE = agent.AGENCE AND QUOTA >= '350000';

/*25 serait est commentaire*/
/*4*/

SELECT *  FROM CLIENTS cli,VENDEURS vend WHERE NOM ='Bill Adam' AND cli.CLIENT_VENDEUR = vend.NUM_SALARIE;

/*5*/
/*REVOIR */
SELECT * FROM PRODUITS WHERE CODE_FABRICANT ='ACI' AND  QUANTITE_EN_STOCK > 139;
/*6*/
SELECT NOM,AGE,NUM_AGENCE,TITRE, vend.VENTES FROM VENDEURS vend, AGENCES agent WHERE VEND.NUM_AGENCE = agent.AGENCE AND agent.VENTES>OBJECTIF;

/*7*/
SELECT NOM, AGE, NUM_AGENCE ,TITRE, MANAGER FROM VENDEURS vend, AGENCES agent WHERE vend.NUM_AGENCE = agent.AGENCE  AND NOT CHEF ='108';

/*8*/
SELECT NUM_CLIENT FROM CLIENTS cli,COMMANDES com AND