Hello. Display the code and description of the group and the quantity of products associated with each of the groups. Order the result by the quantity of products in each group. I have difficulty in how to do this part "and the amount of products associated with each of the groups". Below is my GROUP table and my PRODUCT table.
The first two columns is my GROUP table. The remainder is the PRODUCT table. I have the following Query:
select group.codgru, group.description
from group, product
where
order by