Find attached the Adventureworks dataset, consisting of $4$ tables: Customers, Orders, Order Detail and Products. Load them up into MySQL and create the SQL queries below. Show me the query and query results in a PDF$.$

Only one Submission should be made per group.

$1.$ How many distinct orders were made by customers with a CustomerID $>15000$ in Territories $7-10,$ inclusive? $($The result should be just ONE number$)$

$2.$ What is the total of all orders under the average order amount in Territories $2-10?($The result should be just ONE number$)$

$4.$ What were the top $10$ best$-$selling products, by number of orders? $(2$ columns, $10$ rows: Product, # of orders. Count the number of orders that contain each product and choose the top ten that have most orders. $)$

$5.$ Who were the top $10$ best customers, by dollar amount? $(2$ columns, $10$ rows: Product, $ amount$)$

$6.$ List all products over the $70$th$-$percentile of sales $($Variable number of Product Names$)$

$7.$ What is the average unit price discount for all sold items? $($One Number$)$

$8.$ List the products and quantities purchased by the top $5$ customers and their dollar value. $($Output is $3$ Columns, multiple $(>5)$ rows: Product, Quantity, dollar amt. It is for top $5$ customers aggregated$)$