Problem Statement
Write a query to find the total sales revenue generated (sum of `total_amount`) for each product category. Show the `category` and the sum aliased as `total_revenue`, sorted from highest to lowest revenue.
Skills Evaluated
GROUP BYSUMJOINORDER 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