In the SQL folder there are stored procedures that I wrote to demonstrate using CASE, CAST, Temporary Tables, JOIN's, Aggregate Functions, Subqueries, Common Table Expressions, Window Functions, and ...