Question · SQL and MySQL course · Module 8: Subqueries

Aggregate functions in a subquery

Which aggregate function in a scalar subquery returns the most recent year of publication of a book?

Answer options

  • (SELECT MIN(rok_wydania) FROM ksiazki)
  • (SELECT COUNT(rok_wydania) FROM ksiazki)
  • (SELECT MAX(rok_wydania) FROM ksiazki)
  • (SELECT SUM(rok_wydania) FROM ksiazki)

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