Problem Statement
Write a query to find the second highest product `price` in the `products` table. Return it as a single value under the column name `second_highest`. (Note: This is the exact SQL design used in the classic 'Second Highest Salary' interview question, applied here to our products schema).
Skills Evaluated
SubqueryMAXNested SELECT
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