>select week, id, sum(hrs) as week_hrs, count(???) as week_cnt from >mytable group by week, id >>
CREATE CURSOR crsTest (ID C(10), Week I, Hrs N(10,2)) INSERT INTO crsTest VALUES ([ID1], 1, 12) INSERT INTO crsTest VALUES ([ID1], 1, 12) INSERT INTO crsTest VALUES ([ID1], 1, 12) INSERT INTO crsTest VALUES ([ID1], 1, 12) INSERT INTO crsTest VALUES ([ID1], 1, 12) INSERT INTO crsTest VALUES ([ID1], 1, 12) INSERT INTO crsTest VALUES ([ID1], 1, 12) INSERT INTO crsTest VALUES ([ID1], 1, 12) INSERT INTO crsTest VALUES ([ID1], 2, 12) INSERT INTO crsTest VALUES ([ID1], 2, 12) INSERT INTO crsTest VALUES ([ID1], 2, 12) INSERT INTO crsTest VALUES ([ID1], 3, 12) INSERT INTO crsTest VALUES ([ID2], 1, 12) INSERT INTO crsTest VALUES ([ID2], 1, 12) INSERT INTO crsTest VALUES ([ID2], 1, 12) INSERT INTO crsTest VALUES ([ID2], 2, 12) INSERT INTO crsTest VALUES ([ID2], 2, 12) INSERT INTO crsTest VALUES ([ID2], 2, 12) INSERT INTO crsTest VALUES ([ID2], 4, 12) select week, id, sum(hrs) as week_hrs, count(*) as week_cnt from crsTest group by week, id