Hands-on task
SQLite: LEFT JOIN and customers without orders
The database /root/shop.db has tables customers(id, name) and orders(id, customer_id, amount). You need to find customers who have no orders at all and write their names (one per line) to /root/out.txt.
Data hint: some customers have no orders whatsoever — those are exactly the ones you need to get.
- sqlite3
- left join
- is null
- anti-join
- sql