SQL query question

From: XaFTek <xaf_at_tekano.fr>
Date: 20 Jul 2001 09:32:04 -0700
Message-ID: <1011570f.0107200832.a09af62@posting.google.com>

I have a table like

create table data
(

 id        integer not null, // PK
 idSociety integer not null,
 idPeople  integer not null,
 billing   integer not null,

 dateDate date not null
)

I would like to know in one SQL query which is the idPeople, for a group of idSociety, who have the more SUM(billing) beetween two date.

The result will be like:

idSociety idPeople SUM(billing)
--------- -------- ------------

10        12       102330
12        25       1552665
2545      35847    12455

I can't find it.

Thank's in advance Received on Fri Jul 20 2001 - 11:32:04 CDT