Problem Statement
Calculate the exact median `total_amount` of all completed orders in the `orders` table. Return the result as a single value aliased as `median_amount`.
Skills Evaluated
MedianROW_NUMBER OVERCTEMath Average
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