Description: Example of using SQL code from Project 2 of Udacity's Business Analytics Nanodegree
(2023) This project comes from Udacity's Business Analytics Nanodegree program. The purpose of the courses in this track is to obtain foundational skills in using Excel, SQL, and Tableau. In this project, Udacity provided us students with a sample database of an online music store named Chinook located in Canda, with data from 2009-2013. Instructions included creating tables to solve our own questions about the database using at least 2 different tables with JOIN, and aggregation functions (SUM, COUNT, AVG, etc.).
This repository includes a .txt file with 4 different queries performed on the sample data. To run these queries with a SQL application:
- The chinook.db database is compressed into a zip file available for download in this repo here
- The ck_queries.txt files include 4 different blocks. You can select the code from in between the
\*QUERY*\title and the\*END*\comment of each block to generate the tables
The code blocks found inside of the the text file can be used to generate the following tables:
- By Country: Ratio of Sales Representatives to Customers vs. Number of Invoices
- Artist Frequency Across Playlists
- Purchases of Metal Tracks by U.S. Customers from 2009-2013
- Latin Music Sales by Countries Repesented by Chinook Customers from 2009-2013
You can see the results of each query as a chart here .
Purpose: This repository is meant to speak to my skillset by serving as an example of SQL Code. Please feel free to review and reach out to me.