SQL noob question, grouping results.

[spiroom]

Hi, I have a simple table like this:

3 fields:
code of person | code of workcenter | code of office

1	wc1	of1
2	wc1	of2
3	wc1	of2
4	wc1	of3
5	wc2	of1
6	wc2	of1
7	wc2	of2
8	wc2	of2

I need the SQL instructions to obtain the list of workcenters (two rows), the number of offices for each center and the number of persons for each,
This will be the result:

wc1 | 3 | 4
wc2 | 2 | 4

it may be easy, but I am unable to find the solution with a simple Select.
Please help and suggestions!
Thanks in advance!!!

[June7]

No, won't be simple.

Query1
SELECT workcenter, Count(office) AS CountOffice FROM (SELECT DISTINCT workcenter, office FROM table) AS Q1 GROUP BY workcenter;

Query2
SELECT workcenter, Count(person) AS CountPerson FROM table GROUP BY workcenter;

Query3
join the first two

[spiroom]

Thanks June7 !!!!

I thought that could be done with a single statement, ... thank you sincerely .