<font color="midnightblue" face="Verdana, Arial, Helvetica" size="2"><span>hi,<br />I need some help in creating a
sql.<br/>the problem is as below.<br /><br />assume that:<br />I am a store keeper <br /> and I have the list of
customer(user_id)transactions in my order table.<br />schema: Orders(order_id, user_id, amount_paid,
create_timestamp)<br/><br />I want to give discount of 10% for the customer who made orders of worth (sum) at least
$500in the least time from now (i.e last few days, but NOT ALL TIME LEAST TIME TO BUY $500 WORTH GOODS).<br />and 9%
discountfor the customer who made $500 in second least time from now.<br />and so on<br /><br /></span></font><font
color="midnightblue"face="Verdana, Arial, Helvetica" size="2"><span>there is no time constraint.<br /> it customer
couldtake any amount of time to make $500.<br />the customer might not even made $500 bill till now in that case I
shouldget the first date.<br /><br />the result can take upto the first entry time of the table itself.<br /><br />in
shortits like sum up entries of each user in order table backwards (i.e from last entry to the first) and find the
entrythat has sum > $500. <br />If there is some user who didnt even make 500 till now in my shop return the first
dateof transaction/order</span></font>.<br /><br />can anyone help me on this?
