SQL/ Data visualization: Video game Sales

This project was to practice my SQL and PowerBi. I am learning SQL and wanted to demonstrate my experience and skills using SQL. I first found a video game sales database on Kaggle, I then downloaded an Excel file and uploaded it onto a database in SSMS and named it [Video Game].

My code was to search for the top total sales in North America by the name of the game. I partitioned it by the name of the game and looked for the total sum of North America’s total sales. I filtered the data so that the publishers are Nintendo and look for games that start with “P”. I did this because I wanted to see how many Pokemon games made the top 10 in sales. Because I am a Pokemon fan!

Beforehand I created a common table expression to clean the data to find the publisher and North America sales and the name of the game. It will come from the table vgsales.