- Description: This project takes three CSV files to create a database with three tables.
- Files:
create-database.py
: Creates the database with three tables:Inventory
,Products
, andSales
.query-top-ten.py
: Returns a formatted table displaying stores, their best-selling products, and associated profits.
https://github.com/jaymasl/duckdb-database-work/tree/master/national-store-chain
Script output:

A clearly well formatted list showing the top performing stores, total sales, most sold product, unit price, product cost, and profit. This was retrieved from 20,000 lines of sales data in Sales.csv.
Leave a Reply