Re: need help in building a query

none can help me?

On Tue, Nov 4, 2008 at 9:08 PM, Devil™ Dhuvader <gibsosmat(at)gmail(dot)com> wrote:

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