Hands-on task
This task is step 2 of the course “SQL with SQLite”
SQLite query into a file
The database /root/shop.db has a table orders(id, amount). Compute the sum of all amount and write the number to /root/revenue.txt.
What you'll practise:
- sqlite3
- sql
- aggregate functions
- output redirection