Erstelle eine SQL-Abfrage, um alle Kund:innen zu finden, die in den letzten sechs Monaten mehr als 1000 € ausgegeben haben.
SELECT customer_id, SUM(amount) AS total_spent
FROM transactions
WHERE transaction_date >= DATE('now', '-6 months')
GROUP BY customer_id
HAVING total_spent > 1000;
SELECT customer_id, SUM(amount)
FROM transactions
GROUP BY customer_id
HAVING SUM(amount) > 1000;
Baroque art features strong contrasts, while Rococo art prefers more subtle transitions
Baroque art is generally larger in scale than Rococo art
Informatik Übungen werden geladen ...