-- SQL 1-4 review
--
-- Updated May 27, 2025



------------------------------------------------------------------------------------------------
-- Problems 
------------------------------------------------------------------------------------------------


-- 1) How many total rows do we have?


-- 2) How many unique titles?


-- 3) How many people have the most common title?
-- Sales Representative


-- 4) Make a list of all employees with their title, sorted by title
-- Use the format First Last (Title)
-- Enter the 4th item in the list


-- 5) How many people work in North American, Canada, and Mexico?



-- 6) How many unique cities do we ship orders to?


-- 7) How many shipments have we made to each city in France? Sort by count 
-- What city is the 3rd most shipped to?


-- 8) How many rows are in Order Details?


-- 9) What is the average quantity ordered from product id 25?
-- Round to the nearest integer when answering


-- 10) What is the sum and average quantity ordered from every product? 
-- Round all averages to 0 decimal points.
-- Sort by the sum
-- Only show products with over an average over 30 
-- What is the sum of quantity for the last item in the list?
