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.