Hi,

I am trying to get total number of products in different departmental stores and i also want to get the name of the product. I have this query.

Select count(prod) as cnt, prodname from distribution
not working