Skip to content

misszeferino/SQL-Projects

Repository files navigation

SQL Projects Repository

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.

Table of Contents

Introduction

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.

Tools

MySQL BigQuery SQLite Python

Projects

  1. 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
  2. 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
  3. 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
  4. 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

Contact

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!

Releases

No releases published

Packages

No packages published