Hi, sorry if this is a newbie question -
Simplifying our order table into CustomerId, OrderDate, OrderTotal
I've been asked to write a query to identify customers who have Sum(OrderTotal) > x in any 6 month period over the last 3 years. So for some customers they may exceed that Jan 25 '18 - Feb 25 '18, some could exceed it Dec 25 '18 - Apr 5 '19 etc.
I'm not a sql expert, am struggling, and have a rather tight deadline to get this done so I would be super grateful for any help with this query. Thank you.