Project Title

Second-Hand Cars Sales Analysis Using SQL

Objective

This project analyzes second-hand car sales data to understand pricing trends, demand patterns, and key factors affecting car resale value using SQL.

Problem Statement

To analyze:

Which car brands are most sold in second-hand market How price varies with age, mileage, and fuel type Which factors affect resale value the most Demand trends in used car market

Domain Automobile Industry 🚗 Data Analytics 📊 Sales & Market Analysis

Tools Used

SQL 🗄️ MySQL / SQLite

Key SQL Concepts Used

SELECT statements WHERE filtering GROUP BY aggregation ORDER BY sorting JOIN operations COUNT / AVG / SUM functions

Key Insights

Certain brands have higher resale value Mileage strongly affects car price Diesel vs Petrol price differences exist Older cars generally have lower value Specific models dominate used car market

Dataset Information Dataset includes:

Car_Name Brand Year Price Fuel_Type Mileage Seller_Type Sample Query SELECT brand, AVG(price) AS avg_price FROM cars GROUP BY brand ORDER BY avg_price DESC;

Project Outcome

This project helps to:

Understand used car market trends Analyze price distribution Support buying/selling decisions Practice real-world SQL analysis

Author Pimika Roy Aspiring Data Analyst | SQL | Python | Power BI Learner

⭐ Support

If you like this project, please ⭐ the repository.