SELECT DISTINCT Nom, Prenom FROM Employes ORDER BY Nom DESC, Prenom ASC;

ORDER BY Nom FROM Employes;

SELECT * FROM Employes ORDER BY Nom DESC, Prenom ASC;

SELECT * FROM Employes ORDER BY Prenom DESC;

SELECT * FROM Ventes WHERE EmployeID = 4 ORDER BY MontantTotal DESC;

SELECT * FROM Employes WHERE EmployeID = 4;

SELECT DISTINCT VenteID, MontantTotal FROM Ventes WHERE EmployeID = 4 ORDER BY MontantTotal DESC;

SELECT MontantTotal FROM Ventes;

SELECT DISTINCT Nom FROM Clients WHERE Nom LIKE '%on%';

SELECT * FROM Clients WHERE Nom LIKE '%on%';

SELECT Nom FROM Clients;

SELECT * FROM Clients WHERE Nom LIKE 'on%';

SELECT * FROM achats WHERE produit LIKE 'iPhone' OR montant > 800;

SELECT * FROM achats WHERE produit = 'iPhone' AND montant > 800;

SELECT * FROM achats WHERE produit LIKE 'iPhone%' AND montant >= 800;

SELECT * FROM achats WHERE produit LIKE '%iPhone%' AND montant > 800;

SELECT * FROM Produits WHERE FournisseurID = 13;

SELECT ProduitID FROM Produits;

SELECT * FROM Fournisseurs WHERE FournisseurID = 13;

SELECT DISTINCT NomProduit FROM Produits WHERE FournisseurID = 13;