Problem: Premiere Products
A. For each part, list the part number, description, units on hand, order number, and number -- of units ordered. All parts should be included in the results. For those parts that are currently not on order, -- the order number and number of units ordered should be left blank. Order the results by part number. --
B. Use a subquery to find the rep number, last name, and first name of each sales rep who represents at least one customer with a credit limit of $10,000. List each sales rep only once -- in the results. -- Henrys Books --
C. Find the book code and book title for each book whose price is more than $10 or that was published in Boston. -
D. Find the book code and book title for each book whose price is more than $10 and that was published in Boston.