simple query help

i have a table as follows (#1). i would like to have a report that gave the following (#2). can anyone help me?

(#1)

dept	dude	status
====	====	======
north,	bob,	i,
north,	jim,	a,
north,	sam,	i,
north,	jeff,	a,
north,	mary,	a,
north,	sal,	a,
east,	mary,	a,
east,	dwaine,	i,
east,	tom,	i,
east,	bill,	i,
east,	chuck,	a,
south,	matt,	a,
south,	holly,	a,
west,	joy,	i,
west,	stacy,	a,

(#2)

dept	active	inactive	
====	======	========
north	4	2
east	2	3
south	2	0
west	1	1