1SELECT
2 ordernumber,
3 SUM(quantityOrdered) AS itemsCount,
4 SUM(priceeach*quantityOrdered) AS total
5FROM
6 orderdetails
7GROUP BY
8 ordernumber
9HAVING
10 total > 1000;
1SELECT colonne1, SUM(colonne2)
2FROM nom_table
3GROUP BY colonne1
4HAVING fonction(colonne2) operateur valeur