Welcome to the SQL Projects Repository! This repository contains a collection of SQL queries used for various school projects and real-life scenarios encountered during my work as a Data Analyst.
This repository serves as a comprehensive resource for SQL queries that can be used for educational purposes, practice, and real-world data analysis tasks. Each query is carefully crafted and documented to facilitate understanding and reuse.
-
Monitoring Vehicle Odometer Mileage for Monthly Bookings
- Industry: Shared Mobility
- Description: Monitor the total mileage recorded on vehicle odometers at the end of each month for every booking.
- Tools: BigQuery
- Project File: Link to query file
-
Battery Alert System for Electric Vehicles
- Industry: Shared Mobility
- Description: Identify vehicles with insufficient battery to return to the starting point of their trip
- Tools: BigQuery
- Project File: Link to query file
-
Customer Data and Seller Performance Analysis at Olist (French)
- Industry: E-commerce
- Description: SQL queries to address specific questions related to customer purchases and seller performance.
- Tools: SQLite et Python
- Project File: Link to query file
-
Analysis of Real Estate Sales in France (French)
- Industry: Real Estate
- Description: This project focuses on analyzing real estate sales across France using data from Laplace Immo. The study utilizes SQL queries to explore various aspects of the property market, such as geographic distribution, price per square meter, and sales trends over time.
- Tools: MySQL
- Project File: Link to query file
If you have any questions or would like to discuss my work further, feel free to reach out:
Thank you for visiting my repository, and I hope you find these projects insightful!