Project Brief
Your task for today’s project is to query data from an SQL database.
Step-By-Step Instructions
Download this data.db database file.
The database contains an invoices table which contains the following data.
Create a Python script that prints out all the rows that have Germany as the BillingCountry and have a Total of 2.0 or more.
Expected Output
Environment Setup Instructions
You don’t need to install any libraries. You can use sqlite3 which is a standard library.
Place the data.db file in the same directory with your main.py file.
Run the script with python main.py
Resources
Learn how to create databases, tables, insert, query, update and delete data using Python and SQLite:
https://pythonhow.com/what/working-with-sqlite-python/
Project Solution
Feel free to post your questions or comments in the comment section below.
Happy Coding!
Daily Python Projects Team