sql-database-using-python

Customer Sales Analysis using MySQL and Python

This project connects to a MySQL database, fetches customer-wise sales data, and visualizes the total purchase amount using a bar chart.

---

Features

• Connects to a MySQL database (ai_resume)
• Runs a SQL query on the sales_data table
• Calculates total sales per customer
• Displays the results using a bar chart (Matplotlib)

---

Requirements

• Python 3.x
• pymysql for MySQL connection
• matplotlib for data visualization
• MySQL Server with a database named ai_resume and a table sales_data