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:
- SELECT tytul AS Tytul, cena AS Cena
- FROM ksiazki
- ORDER BY cena DESC
- LIMIT 3