CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 5

Question 4. 4. (TCO 8) In a table named ORDER, there is a column
named SHIPDATE that contains a date for each order that has been
shipped. Write the query that would show the number of orders that
have been shipped. List the column name as Number of Orders
Shipped for this derived column.
Question 5. 5. (TCO 6) Write the SQL statement that will remove the
database table EMPLOYEE.
Question 1. 1. (TCO 7) Write a join query that for every order placed
on September 5, 1998, (use '05-SEP-1998') will list the order number
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.