Postgress Query SQL

0

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

    
asked by anonymous 10.10.2018 / 17:40

0 answers