Solutions

Solution Exercice 1 :

SELECT ville, COUNT(*) AS nombre_clients
FROM clients
GROUP BY ville;

Solution Exercice 2 :

SELECT id_client, SUM(montant_total) AS total_commandes
FROM commandes
GROUP BY id_client
ORDER BY total_commandes DESC;