Intro to SQL - Lesson 2 - Operators & Functions
A look at the some of the core SQL operators and functions
1. Get Number of Products in Each Category
2. Find the Order number that had the most products ordered, how many products were ordered?
3. What shipper do we ship with the most overall, and how many orders did we ship with them? in 1997? in 1997?
4. What is the average length of our employee's first names?
Get a list of all our clients addresses in the format: Address, City, PostalCode, Country
5. Which employees have a birthday in August?