Hands-on task
This task is step 4 of the course “Your first database”
ORDER BY and LIMIT: the three most expensive
The shop window needs the three most expensive products from the goods table (database /root/shop.db).
Write their names to /root/top3.txt — one per line, from the most expensive down.
What you'll practise:
- sqlite3
- order by
- desc
- limit