SQL Repository: A showcase of my SQL expertise, featuring comprehensive notes and examples that demonstrate my ability to solve complex problems with efficient and elegant SQL statements.
- Confirmation Rate Problem. Confirmation Rate
- Needed a list of Orders and their corresponding items in a comma separated list. Orders List
- Return a list of dates that "Handcrafted Pizza" was ordered. Pizza Problem
- Return a list of Items and their Original Prices, Discounted Percentages, and Discounted Prices Seasonal Sale Problem
- Special Vendor List for our Store. Vendor Employee List
- Date Functions. This holds sql statements used to convert dates or find the final days of the month. Dates SQL
- Mathmatical Operations. This file basically holds functions that I've found helpful. Such as knowing how to calculate a rolling total. Math SQL
- String Functions. Very basic sql statements on how to perform some string functions. String SQL