-- 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 f.ville=c.ville); 
 
-- Q6
select nom from client union select nom from fournisseur;
 
-- Q7
select id_med, nom from medicament where id_med in(select id_med from Archive_Medicament);
 
-- Q8
select count(*) from commande;
select distinct 'Yes it EXISTS' as 'Commande' from commande where exists(select 1 from commande);
 
-- Q9
select distinct famille from medicament;
 
-- Q10;
select id_med from Medicament where id_med not in(select id_med from ligneCommande); 
 
 

LS0gUTEKc2VsZWN0IGRpc3RpbmN0IHZpbGxlIGZyb20gY2xpZW50OwotLSBRMgpzZWxlY3Qgbm9tIGZyb20gbWVkaWNhbWVudCB1bmlvbiBzZWxlY3Qgbm9tIGZyb20gYXJjaGl2ZV9tZWRpY2FtZW50OwotLSBRMwpzZWxlY3Qgbm9tIGZyb20gbWVkaWNhbWVudCB1bmlvbiBhbGwgc2VsZWN0IG5vbSBmcm9tIGFyY2hpdmVfbWVkaWNhbWVudDsKLS0gUTQKc2VsZWN0IGRpc3RpbmN0IHZpbGxlIGZyb20gY2xpZW50IHdoZXJlIHZpbGxlIGluKHNlbGVjdCB2aWxsZSBmcm9tIGZvdXJuaXNzZXVyKTsKCi0tIFE1CnNlbGVjdCBkaXN0aW5jdCB2aWxsZSBmcm9tIGNsaWVudCBjIHdoZXJlIGV4aXN0cyhzZWxlY3QgdmlsbGUgZnJvbSBmb3Vybmlzc2V1ciBmIHdoZXJlIGYudmlsbGU9Yy52aWxsZSk7IAoKLS0gUTYKc2VsZWN0IG5vbSBmcm9tIGNsaWVudCB1bmlvbiBzZWxlY3Qgbm9tIGZyb20gZm91cm5pc3NldXI7CgotLSBRNwpzZWxlY3QgaWRfbWVkLCBub20gZnJvbSBtZWRpY2FtZW50IHdoZXJlIGlkX21lZCBpbihzZWxlY3QgaWRfbWVkIGZyb20gQXJjaGl2ZV9NZWRpY2FtZW50KTsKCi0tIFE4CnNlbGVjdCBjb3VudCgqKSBmcm9tIGNvbW1hbmRlOwpzZWxlY3QgZGlzdGluY3QgJ1llcyBpdCBFWElTVFMnIGFzICdDb21tYW5kZScgZnJvbSBjb21tYW5kZSB3aGVyZSBleGlzdHMoc2VsZWN0IDEgZnJvbSBjb21tYW5kZSk7CgotLSBROQpzZWxlY3QgZGlzdGluY3QgZmFtaWxsZSBmcm9tIG1lZGljYW1lbnQ7CgotLSBRMTA7CnNlbGVjdCBpZF9tZWQgZnJvbSBNZWRpY2FtZW50IHdoZXJlIGlkX21lZCBub3QgaW4oc2VsZWN0IGlkX21lZCBmcm9tIGxpZ25lQ29tbWFuZGUpOyAKCg==