intermediateAggregation 5m est

Total Stock Count per Category (Scenario 73)

Problem Statement

Calculate the total stock quantity and average price of all products in the 'Accessories' category.

Skills Evaluated

SUMAVGWHERE
Write your SQL query in the editor on the right and click **Run Query**. The system runs your query and compares the result dataset with the official solution. Results must match row-for-row, column-for-column.

Expected Output Format

Executing expected result set...
SQL Query WorkspaceSQLite v3.45 (WASM Mode)
QUICK INSERT:
1