This repository contains my solutions to the practice questions that are located throughout the Mode Analytics SQL Tutorial. The tutorial is broken down into three sections Basic, Intermediate and Advanced.
/basic.sql– SELECT statements, filtering, sorting, aggregates, Comparison operators, Logical operators./intermediate.sql– Aggregate Functions, Joins, Unions, and Self joins./advanced.sql– Data Wrangling, Subqueries, Windows Functions, Pivots.
The file /datasets/ contains the csv file for each data set that was used throughout the tutorial.