Task 7-Get Basic Summary from a Tiny SQLite Database using Python
Objective: Use SQL in Python to extract simple sales insights (total quantity, total revenue) from a SQLite database and visualize them using matplotlib.
Tools Used: -Python (sqlite3, pandas, matplotlib) -SQLite (built-in) -.py file
Files: sales_data.db – Sample sales data Untitled1.ipynb – Python script to connect, query, and visualize sales_chart.png – Output bar chart README.md – Documentation
Steps Performed: -Created a SQLite database with sample sales data -Queried total quantity and revenue by product -Printed results using Pandas -Created a bar chart using matplotlib