This project analyzes e-commerce sales and inventory data using SQL.
It includes database design, sample data, and queries to generate insights on orders, customers, products, and inventory.

• SQL (MySQL)

• schema.sql – database schema (tables for customers, products, orders, inventory)
• insert_data.sql – sample data for testing
• queries.sql – SQL queries for analysis (sales, customer trends, inventory tracking)

• Designed and optimized an e-commerce database.
• Wrote SQL queries for sales insights, customer behavior, and inventory status.
• Identified best-selling products, repeat customers, and low-stock alerts.

1. Clone the repository:

   git clone https://github.com/your-username/ecommerce-sql-analysis.git
   cd ecommerce-sql-analysis

2. Import schema.sql into your SQL database.

3. Run insert_data.sql to add sample data.

4. Use queries from queries.sql to explore insights.

Harshitha Adicherla