getting a unique count of type

[webnick]

Any advise on getting a grouping of pages by type in this query?

select count(*) as 'count' from node n
join node_revisions nr on nr.nid=n.nid
where nr.uid=%author% and n.status=1
group by n.type

This isn't giving me distinct node ids?

Thanks

[Weedpacket]

select count(n.type) .....