-- Question 1
select distinct ville from client;
 
-- Question  2
 
select nom from medicament 
union
select nom from archive_medicament;
 
-- Question 3
select nom from medicament 
union all
select nom from archive_medicament;
 
-- Question 4
select distinct ville from client where ville in (select ville from fournisseur);
 
-- Question 5
select ville from client c where exists(select 1 from fournisseur f where c.ville=f.ville);
 
-- Question 6
select nom from client union select nom from fournisseur;
-- Question 7
select id_med from medicament
where id_med in (select id_med from archive_medicament);
 
-- Question 8
select distinct 'Oui' as 'Enregistré dans le systeme' from Commande where exists( select 1 from Commande);
 
select count(*) from commande;
 
-- question 9
 select distinct famille from Medicament;
 
 -- question 10
 select id_med from medicament where id_med not in(select id_med from LigneCommande);

LS0gUXVlc3Rpb24gMQpzZWxlY3QgZGlzdGluY3QgdmlsbGUgZnJvbSBjbGllbnQ7CgotLSBRdWVzdGlvbiAgMgoKc2VsZWN0IG5vbSBmcm9tIG1lZGljYW1lbnQgCnVuaW9uCnNlbGVjdCBub20gZnJvbSBhcmNoaXZlX21lZGljYW1lbnQ7CgotLSBRdWVzdGlvbiAzCnNlbGVjdCBub20gZnJvbSBtZWRpY2FtZW50IAp1bmlvbiBhbGwKc2VsZWN0IG5vbSBmcm9tIGFyY2hpdmVfbWVkaWNhbWVudDsKCi0tIFF1ZXN0aW9uIDQKc2VsZWN0IGRpc3RpbmN0IHZpbGxlIGZyb20gY2xpZW50IHdoZXJlIHZpbGxlIGluIChzZWxlY3QgdmlsbGUgZnJvbSBmb3Vybmlzc2V1cik7CgotLSBRdWVzdGlvbiA1CnNlbGVjdCB2aWxsZSBmcm9tIGNsaWVudCBjIHdoZXJlIGV4aXN0cyhzZWxlY3QgMSBmcm9tIGZvdXJuaXNzZXVyIGYgd2hlcmUgYy52aWxsZT1mLnZpbGxlKTsKCi0tIFF1ZXN0aW9uIDYKc2VsZWN0IG5vbSBmcm9tIGNsaWVudCB1bmlvbiBzZWxlY3Qgbm9tIGZyb20gZm91cm5pc3NldXI7Ci0tIFF1ZXN0aW9uIDcKc2VsZWN0IGlkX21lZCBmcm9tIG1lZGljYW1lbnQKd2hlcmUgaWRfbWVkIGluIChzZWxlY3QgaWRfbWVkIGZyb20gYXJjaGl2ZV9tZWRpY2FtZW50KTsKCi0tIFF1ZXN0aW9uIDgKc2VsZWN0IGRpc3RpbmN0ICdPdWknIGFzICdFbnJlZ2lzdHLDqSBkYW5zIGxlIHN5c3RlbWUnIGZyb20gQ29tbWFuZGUgd2hlcmUgZXhpc3RzKCBzZWxlY3QgMSBmcm9tIENvbW1hbmRlKTsKCnNlbGVjdCBjb3VudCgqKSBmcm9tIGNvbW1hbmRlOwoKLS0gcXVlc3Rpb24gOQogc2VsZWN0IGRpc3RpbmN0IGZhbWlsbGUgZnJvbSBNZWRpY2FtZW50OwogCiAtLSBxdWVzdGlvbiAxMAogc2VsZWN0IGlkX21lZCBmcm9tIG1lZGljYW1lbnQgd2hlcmUgaWRfbWVkIG5vdCBpbihzZWxlY3QgaWRfbWVkIGZyb20gTGlnbmVDb21tYW5kZSk7