Hands-on task
This task is step 3 of the course “SQL with SQLite”
SQLite: unique cities (DISTINCT)
The database /root/shop.db has a table visits(id, city) where cities repeat. Output the list of unique cities (no duplicates) and write it to /root/out.txt (one city per line).
Reference:sqlite3
What you'll practise:
- sqlite3
- distinct
- unique values
- deduplication