Hi,
We are looking to find a unique number of orders for under $100 for a season. We are hoping this can help us get an idea on offerings to certain patrons with orders under or over that amount. I see I can sort by paid amount under a certain amount, but I think my numbers are a bit inflated that way. I think I need to edit a formula on Order ID, just not sure how to quickly find it. We are looking to get this asap, so hoping someone has a quick answer!
Thanks!
select distinct order_no from t_order a where a.tot_due_amt < 100
or
select distinct customer_no from t_order a where a.tot_due_amt < 100
Thanks Brian - I sent your select statement to our IT manager. She is working on that now.