need help in building a query - Mailing list pgsql-sql

From Devil™ Dhuvader
Subject need help in building a query
Date
Msg-id aaa67ada0811040738g7c3efc37xc0592fb9b4c8c5d9@mail.gmail.com
Whole thread Raw
Responses Re: need help in building a query
List pgsql-sql
<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?  

pgsql-sql by date:

Previous
From: "Bart van Houdt"
Date:
Subject: RE: [SQL] Display message to user
Next
From: Peter Eisentraut
Date:
Subject: Re: Display message to user