Problem Statement
Find the total number of orders placed by each customer. Retrieve the customer_id and the order count aliased as `order_count`, sorted by `order_count` descending.
Skills Evaluated
GROUP BYCOUNTORDER BY
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