Required query (textbook pg 105-115, modified):

(1)For which items are there at least 5 units in quantity on hand?

(2)List the invoice number, dates, and salesperson for sales made to Rodney Wern.

(3)List the dates, description, and quantality for each transaction in which Stainless-color appliances were sold in October.

4)List description and sum of quantity of inventory types that sold 2 or more units in October.

 

(5) List sale date and invoice total for each invoice in October.

(6) List total sales ($) by salesperson in October, sort by largest sales amount to smallest.

(7) Report total sales ($) by state.

(8) Compute the markdown for each item sold. Calculate markdown as (SoldPrice-ListPrice)/ListPrice. List description, color, and average markdown by types and colors, sort by largest average markdown (most negative) to smallest.

Answer rating: 100% (QA)

Query Analysis for Inventory Management System Items with at least 5 Units in Quantity on Hand To id... View the full answer