CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 26

for each part in item class AP. Give the expression an alias
of "On Hand Value".
3. (TCO 8) Write a sub query 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.
4. (TCO 7) Using the BETW