Welcome to the Mobile Manufacturers Data Analysis project! This project focuses on analyzing data related to mobile manufacturers using SQL. The main skills utilized in this project include joins, subqueries, and window functions. The goal is to gain valuable insights into the performance and trends of different mobile manufacturers.
Project Structure The project is organized into the following directories:
queries: Contains SQL queries used for data analysis. data: Placeholder for the dataset used in the analysis. docs: Documentation related to the project, including this README file. Skills Utilized The primary SQL skills applied in this project are:
Joins: Used to combine data from multiple tables, enabling a comprehensive analysis of mobile manufacturer data.
Subqueries: Employed to break down complex queries into simpler, more manageable parts, enhancing the readability and maintainability of the code.
Window Functions: Applied to perform calculations across a set of table rows that are related to the current row, providing valuable insights into trends and patterns.