Put in order · SQL and MySQL course · Module 2: Querying data (SELECT)

Clauses of a full report

Arrange the clauses of a full report in the correct order in which we write them in MySQL (top to bottom):

Items to put in order

  • ORDER BY cena DESC
  • LIMIT 3
  • FROM ksiazki
  • SELECT tytul AS Tytul, cena AS Cena
Show the answer

Correct order:

  1. SELECT tytul AS Tytul, cena AS Cena
  2. FROM ksiazki
  3. ORDER BY cena DESC
  4. LIMIT 3