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.


By Shannon Lowder

Shannon Lowder is the Database Engineer you've been looking for! Look no further for expertise in: Business Analysis to gather the business requirements for the database; Database Architecting to design the logical design of the database; Database Development to actually build the objects needed by the business logic; finally, Database Administration to keep the database running in top form, and making sure there is a disaster recovery plan.

Leave a comment

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