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

A derived table in the FROM clause

Arrange in one line (left to right) the start of a derived table in the FROM clause:

Items to put in order

  • SELECT autor_id, COUNT(*) AS liczba FROM ksiazki GROUP BY autor_id
  • FROM
  • ) AS zestawienie
  • (

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