sql-statements-answered
1.Download the Northwind database attached below.
2.Download the second database and rename it to (Hashim Jamalallail)
Then answer the following questions:
- What employees have last names that begin with “D”?
- What customers have marketing in their title?
- How many territories are there?
- How many territories are there in each region?
- What suppliers are from the USA?
- What’s the average unit price of products?
- What’s the average unit price for and count of products that are out of stock? (stock = 0, not counting things ordered.)
- Which employees have ‘BA’s?
- What are the top 10 orders according to quantity?
- How many regions do each employee work?
11. What were the top 10 orders according to final cost? (quantity x unit cost)
12. What was the average time from order to shipping for each employee? (shipping Date – order date)
*When your done send the second file
*Make sure to rename it to (Hashim Jamalallail)
FILES: