CIS 336 STUDY Career Path Begins/cis336study.com CIS 336 STUDY Career Path Begins/cis336study.com | Page 4

and order date along with the customer number, last name, and first
name of the customer who placed the order.
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 tha t
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 (Devry)

FOR MORE CLASSES VISIT
www.cis336study.com
1. (TCO 1) Most DBMS are referred to as
_____________database management systems. (Points : 4)
elementallinked