Put in order · SQL and MySQL course · Module 8: Subqueries

Steps of building a derived table

Arrange the steps of building a query with a derived table (from first to last step):

Items to put in order

  • Place it in the FROM clause in brackets
  • Reference the derived table's columns in the outer SELECT
  • Write a subquery that returns a summary of the data
  • Give it an alias (e.g. AS zestawienie)

You can check the correct answer by solving this task in the CodeWorlds game.