SQL

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.

Quick Links

Practice Problems:

1. Confirmation Rate Problem. Confirmation Rate

LinkedIn Learning Problems:

1. Needed a list of Orders and their corresponding items in a comma separated list. Orders List
2. Return a list of dates that "Handcrafted Pizza" was ordered. Pizza Problem
3. Return a list of Items and their Original Prices, Discounted Percentages, and Discounted Prices Seasonal Sale Problem
4. Special Vendor List for our Store. Vendor Employee List

Reusuable SQL Statements:

1. Date Functions. This holds sql statements used to convert dates or find the final days of the month. Dates SQL
2. Mathmatical Operations. This file basically holds functions that I've found helpful. Such as knowing how to calculate a rolling total. Math SQL
3. String Functions. Very basic sql statements on how to perform some string functions. String SQL