Re: help with group by

[Adam Williams]

works perfectly, i didn't know you could use multiple columns in the 
group by.  thanks a bunch!

Michael Dykman wrote:
> try this:
>
> select accepted_by, problem_type, count(*) from form
> where problem_type is not NULL
> AND problem_type != 'Test'
> AND accepted_by is not null
> group by accepted_by, problem_type
>