Who has the largest amount for the ytd sales


Problem: Computer Science

Explore AdventureWorks Database. Create SQL queries to answer the questions below.

Submit the executable .sql script (not a word document)

1. How many departments AdventureWorks has?
2. How many employees AdventureWorks has?
3. Who is the chief information officer?
4. What is the lowest and the highest price?
5. How many shipping methods company is using?
6. How many countries (territories) Adventure works DB has?
7. How many Salesperson they have and who takes the largest bonus?
8. Who has the largest amount for the YTD sales?
9. What are the total orders by year?

Request for Solution File

Ask an Expert for Answer!!
Computer Engineering: Who has the largest amount for the ytd sales
Reference No:- TGS03222463

Expected delivery within 24 Hours