SELECT Type, Count(Id)
FROM Account
WHERE Type in ('Prosepct','Other','Customer direct')
GROUP BY Type

Select AccountTypeField, Count(Id) from Account Group by AccountTypeField