Problem Statement
Define a Common Table Expression to isolate orders greater than $600. In the main query, count how many such high-value orders exist per customer.
Skills Evaluated
WITHCTEGROUP BYCOUNT
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