This repository contains SQL queries and analysis performed on a dataset of video games. The dataset includes information such as game rankings, platform, year of release, genre, sales data, critic scores, and user scores.
The objective of this project is to analyze the video games dataset and gain insights into various aspects of the video game industry. The dataset provides valuable information that can be explored through SQL queries to answer questions related to top-selling games, game genres distribution, sales trends, correlations between scores and sales, and more.
By executing the provided SQL queries and analyzing the results, you can explore and interpret the data to draw conclusions and make informed decisions related to the video game industry.
The dataset used for this analysis consists of the following columns:
- Rank
- Name
- Platform
- Year
- Genre
- Publisher
- NA_Sales
- EU_Sales
- JP_Sales
- Other_Sales
- Global_Sales
- Critic_Score
- Critic_Count
- User_Score
- User_Count
- Rating
The repository includes several SQL queries that were used to explore and analyze the video games dataset. The queries cover a range of topics such as top-selling games, distribution of game genres, sales trends, correlations between scores and sales, and more.
Each query is documented with a corresponding question, providing context for the analysis. The results of the queries provide insights into various aspects of the video game industry.
To use this project, you can follow these steps:
- Clone the repository to your local machine.
- Import the dataset into your preferred database management system.
- Execute the SQL queries provided in the vg_queries.sql file.
- Analyze the results and draw conclusions based on the data.
- The dataset used for this analysis is vgsales.csv
This project was created by Ergyun Hasan. If you have any questions or suggestions, feel free to reach out.
Happy querying!