Forum Discussion
No RepliesBe the first to reply
Hello everyone
I'm now working on a project that calls for me to locate every consumer who spent more than $1,000 on goods in the previous 12 months. I believe I've written the correct SQL query, but I'm not sure:
SELECT name
FROM customers
WHERE total_purchases > 1000
AND purchase_date > '2022-01-01';
I need some help to make sure this is the right question.
Question reference from here.