>Naomi
>
>I need to know the number of products in each category just to choose half of the top, ranked by revenue. In your query you get the number of sales operation for each product.
>
>But thanks anyway for your time

Can you post your table structure? I don't see a problem adding a count of products by category to any of your query. but I need to know your tables structure to write the query.