Skills used: Joins, CTE's, Aggregate Functions, Creating Views, Converting Data Types using MS SQL Server Management Studio