Click in order · SQL and MySQL course · Module 8: Subqueries
Running a scalar subquery
Click the elements in the execution order of a query with a scalar subquery (from inside out):
Items to click
- Substitute the average result into the WHERE condition
- Return books more expensive than the average
- Compare each book's price with the average
- Compute (SELECT AVG(cena) FROM ksiazki)
You can check the correct answer by solving this task in the CodeWorlds game.