Daily Python Projects

Daily Python Projects

Share this post

Daily Python Projects
Daily Python Projects
(LEGACY PROJECT) Get Data from Invoices SQL Table
Copy link
Facebook
Email
Notes
More

(LEGACY PROJECT) Get Data from Invoices SQL Table

Level: Real-World

May 20, 2024
∙ Paid
3

Share this post

Daily Python Projects
Daily Python Projects
(LEGACY PROJECT) Get Data from Invoices SQL Table
Copy link
Facebook
Email
Notes
More
Share

This project is a legacy version. Please click the link below to view the latest version of the project.

Updated Version

Project Brief

Your task for today’s project is to query data from an SQL database.

Step-By-Step Instructions

  1. Download this data.db database file.

  2. The database contains an invoices table which contains the following data.

  1. 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

This post is for paid subscribers

Already a paid subscriber? Sign in
© 2025 Ardit Sulce
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture

Share

Copy link
Facebook
Email
Notes
More