Possible to Group By Counts?

[sbroad]

Is it possible to group by counts, I have tried the following sql statement in both mysql 3.23 & 4.01 and it does not work.

select product_type, productPrice, count(*) as temp from product GROUP BY count(productPrice);

What I would like to group is to group on the actual counts, so I can see how many items I have only QTY 3 of or 4 and so on.

I actually need to do this in a couple of places, examle I have another database and I would like to get a count of all persons in that DB who have been used for something, and then group and count them together by the number of times they did it.

Something like 5 different people all together did something 10 times. Because each of them did it twice.

Confusing? I just need to group on counts. A work around maybe?

[kevinsequeira]

not sure what it is that you want, hope this helps

select product_type, productPrice, count(productPrice) from product
group by 1
order by 3

reg
kevin