SQL101-Homework Assignment #6

We’re starting to cover some more difficult subjects in these homework problems.  Please let me know if you need any help!

1.    How many rows are there in Sales.SalesOrderHeader?
2.    How many Rows are there in Sales.SalesOrderDetail, that are also in Sales.SalesOrderHeader (SalesOrderID is the common/shared column)?
3.    How many sales orders (sales.salesOrderHeader) were made by Customer name (you can relate salesOrderHeader to Person.contact on soh.customerID = c.contactID)
4.    Using your last query, how much were those sales worth (sum subtotals)?

UPDATE: Here are the Answers.

 

Leave a Reply

Your email address will not be published. Required fields are marked *