Solutions

Solution Exercice 1 :

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

Solution Exercice 2 :

SELECT MONTH(date_commande) AS mois, SUM(montant_total) AS total_mensuel
FROM commandes
GROUP BY mois
HAVING total_mensuel > 1000;