The SELECT clause produces one summary row for each group, displaying the name of each product and its in-stock average quantity.

• SELECT子句为每一组生成一个摘要行,并且显示每一产品的名称及其库存平均数量。