 Tongela motuna mpo na kopona bakiliya oyo babimisi koleka $1,000 na mobimba na mbula oyo eleki.
Tala requête ya SQL oyo ekoki kosalelama pona kopona ba clients oyo ba dépenser plus de $1,000 en total na année oyo eleki: ```SQL SELECT CustomerId, SUM(TotalAmount) AS TotalSpent FROM Orders WHERE OrderDate BETWEEN DATEADD(year,-1, GETDATE()) NA GETDATE() GROUP NA CustomerId HAVING SUM(TotalAmount) > 1000 ``` Motuna oyo eponaka `CustomerId` mpe somme ya `TotalAmount` mpo na client moko na moko na tableau ya `Orders`. Clause `WHERE` e filtraka ba résultats pona kolakisa kaka ba commandes oyo esalemaki na kati ya mbula eleki. Clause `GROUP BY` esangisi ba résultats na `CustomerId` mpe clause `HAVING` e filtraka ba groupes pona kolakisa kaka oyo esika motuya mobimba oyo client abimisaki eleki 1.000. Résultat ya suka ezali liste ya ba clients oyo ba dépenser plus de 1.000$ na total na mbula oyo eleki.