Hands-on task
This task is step 3 of the course “Your first database”
WHERE: what's out of stock
Which products have run out? In the goods table (database /root/shop.db) the stock column is how many items of a product are in the warehouse.
Write to /root/sold_out.txt the names of the products with zero in stock — one per line. Any order is fine.
What you'll practise:
- sqlite3
- where
- filtering rows