As the Chinook music service has entered the international market, data was gathered and entered a database to be analyzed. The goal is to gather which countries are bringing in the most money to gain insights to inform our decision as to where to allocate our resources.
The data consists of various tables with data on customer, country, invoice, and song/artist information that were queried using a Structured Query Language (SQL) to answer various questions.
As shown above, the top 3 countries with the most customers are The United States, Canada, and Brazil.
The service, as of now, is used in 11 states and is most used in California.
The service, as of now, is used in 7 states and is most used in Ontario.
On average, a customer will spend 5.60 on an invoice and most sales are between 1.98-8.91 per invoice but most of the totals in that range are 1.00-3.00
The highest total invoice amount goes to The United States, followed by Canada, and France and Brazil about tied for thirds.
Most of the audio purchased is music followed by TV shows.
The most popular genres are Rock, Latin, and Metal.