Skip to content

SQL101-Homework Assignment #6

2006 April 3
by Shannon Lowder

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.

 

No comments yet

Leave a Reply

Note: You can use basic XHTML in your comments. Your email address will never be published.

Subscribe to this comment feed via RSS