The following example uses the WHERE clause to get the total number of units in stock for all discontinued products in the Products table.

• 下面的示例使用WHERE子句来获得库存中商品的总数,以便得到Products表中所有停止的产品。