CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 5

Question 2. 2. (TCO 8) Write a query that will list the part number, part description, and
on-hand value (units on hand * unit price) for each part in item class AP. Give the
expression an alias of on-hand value.
Question 3. 3. (TCO 8) Write a subquery that will list the part number, part description,
and units on hand of all parts where the number of units on hand is greater than the
average of units on hand for all parts.
Question 4. 4. (TCO 7) Using the orders table, write a query that will list the order
number, date, and customer number for every order that was made prior to September 5,
1998. Format the date in your result set to be in the same format as above (i.e., September
5, 1998).
Question 5. 5. (TCO 7) Using a NATURAL JOIN method, write a query that will list the
customer number, last name, and first name for every customer who currently has an
order on file for an iron.
--------------- ------------------------------------------------------------------
CIS 336 Final Exam 1
For more course tutorials visit
www.uophelp.com
1. (TCO 1) Most DBMS are referred to as _____________database management
systems. (Points : 4)
elemental
linked