National Store Chain Query DuckDB

  • 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, and Sales.
    • 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.


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *