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.