How many Products reside in each SubCategory?The answer to this is retrievable if you write a query that use the COUNT aggregate function combined with a GROUP BY clause. The column ProductSubcategoryID is a candidate for building groups of rows when querying the Production.Product table. Your result set should look something like the result below. Notice the column alias for the second column.
đang được dịch, vui lòng đợi..
