DP-420: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DBDemo

You have an Azure subscription containing an Azure Cosmos DB for NoSQL account. The account hosts a container named Container1 that stores product inventory data in the following format.

You need to query the average inventory quantity of each product in Washington, including the product name.

How should you complete the query?

SELECT
    p.name,
    Select…
FROM
    products p
Select…
(
    SELECT
        AVG(i.quantity) AS inventoryAverage
    FROM i IN p.inventory
    WHERE ENDSWITH(i.location, "WA")) AS inventoryData