-- Q1
select distinct ville from client;
-- Q2
select nom from medicament union select nom from archive_medicament;
-- Q3
select nom from medicament union all select nom from archive_medicament;
-- Q4
select distinct ville from client where ville in(select ville from fournisseur);
-- Q5
select distinct ville  from client c where exists(select ville from fournisseur f where c.ville = f.ville);
 
-- Q6
select nom from client union select nom from fournisseur;
 
-- Q7
select distinct id_med from medicament where id_med in (select id_med from Archive_Medicament); 
 
-- Q8
select count(*) from commande;
 
select distinct 'Oui' as 'il y a commande' from commande where exists(select id_cmd from commande);
 
-- Q9
select distinct famille from medicament;
-- Q10
select id_med from medicament where id_med not in( select id_med from lignecommande);
 
 

LS0gUTEKc2VsZWN0IGRpc3RpbmN0IHZpbGxlIGZyb20gY2xpZW50OwotLSBRMgpzZWxlY3Qgbm9tIGZyb20gbWVkaWNhbWVudCB1bmlvbiBzZWxlY3Qgbm9tIGZyb20gYXJjaGl2ZV9tZWRpY2FtZW50OwotLSBRMwpzZWxlY3Qgbm9tIGZyb20gbWVkaWNhbWVudCB1bmlvbiBhbGwgc2VsZWN0IG5vbSBmcm9tIGFyY2hpdmVfbWVkaWNhbWVudDsKLS0gUTQKc2VsZWN0IGRpc3RpbmN0IHZpbGxlIGZyb20gY2xpZW50IHdoZXJlIHZpbGxlIGluKHNlbGVjdCB2aWxsZSBmcm9tIGZvdXJuaXNzZXVyKTsKLS0gUTUKc2VsZWN0IGRpc3RpbmN0IHZpbGxlICBmcm9tIGNsaWVudCBjIHdoZXJlIGV4aXN0cyhzZWxlY3QgdmlsbGUgZnJvbSBmb3Vybmlzc2V1ciBmIHdoZXJlIGMudmlsbGUgPSBmLnZpbGxlKTsKCi0tIFE2CnNlbGVjdCBub20gZnJvbSBjbGllbnQgdW5pb24gc2VsZWN0IG5vbSBmcm9tIGZvdXJuaXNzZXVyOwoKLS0gUTcKc2VsZWN0IGRpc3RpbmN0IGlkX21lZCBmcm9tIG1lZGljYW1lbnQgd2hlcmUgaWRfbWVkIGluIChzZWxlY3QgaWRfbWVkIGZyb20gQXJjaGl2ZV9NZWRpY2FtZW50KTsgCgotLSBROApzZWxlY3QgY291bnQoKikgZnJvbSBjb21tYW5kZTsKCnNlbGVjdCBkaXN0aW5jdCAnT3VpJyBhcyAnaWwgeSBhIGNvbW1hbmRlJyBmcm9tIGNvbW1hbmRlIHdoZXJlIGV4aXN0cyhzZWxlY3QgaWRfY21kIGZyb20gY29tbWFuZGUpOwoKLS0gUTkKc2VsZWN0IGRpc3RpbmN0IGZhbWlsbGUgZnJvbSBtZWRpY2FtZW50OwotLSBRMTAKc2VsZWN0IGlkX21lZCBmcm9tIG1lZGljYW1lbnQgd2hlcmUgaWRfbWVkIG5vdCBpbiggc2VsZWN0IGlkX21lZCBmcm9tIGxpZ25lY29tbWFuZGUpOwoK