Thanks for responding. That was the tip I needed.
Regards,
Mark
On Sat, 13 Dec 2003 16:36:32 -0300
Martin Marques <[EMAIL PROTECTED]> wrote:
> El S�b 13 Dic 2003 16:21, MT escribi�:
> > Hi,
> >
> > I have an invoicing system using postgresql. Each time a customer makes a
> purchase, a new record is inserted into the "cart" table. The "cart" table,
> among other things, contains a customer_id field and a total for the amount
> purchased on the particular invoice. Now what I'd like to do is to calculate
> the total invoices for each customer in a given time interval, then list
> those customers in descending order from most paying to least paying. Could
> someone give me some pointers on how to construct an sql statement that would
> flush out this data.
>
>
> First, lets see how to get the info you want:
> SELECT sum(invoice) AS total, customer_id FROM cart
> GROUP BY cuotomer_id;
>
> Now you can order it by the total column, and maybe give it a LIMIT, in case
> you have to many costumers. :-)
>
> --
> select 'mmarques' || '@' || 'unl.edu.ar' AS email;
> -----------------------------------------------------------------
> Mart�n Marqu�s | [EMAIL PROTECTED]
> Programador, Administrador, DBA | Centro de Telem�tica
> Universidad Nacional
> del Litoral
> -----------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
