This repository contains the solutions for the Cryptocurrency case study.
This entire SQL Simplified course focuses on a Cryptocurrency SQL Case Study. In our fictitious case study - Danny's data mentors from the Data With Danny team have been busy trading cryptocurrency markets since 2017.
Our main purpose for this case study is to analyze the performance of the DWD mentors over time. We will accomplish this by writing SQL queries to utilize all available datasets to answer a series of realistic business questions.
Each case-study folder contains the following files
- A readme file explaining the problem statement and datasets used
- SQL file to create the schema and loading data
There are total 5 SQL Simplified labs :
Lab 1: Basic Data Analysis Techniques
Lab 2: Aggregate Functions for Data Analysis
Lab 3: Understanding Case When Statements
Lab 4: Operating Window Functions
Lab 5: Using Table Joins
You can find the solution in the attached file.
Note:
- Solutions are coded in PostgreSQL
Give a ⭐️ if you like this project!