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

3. (TCO 7) Sally needs to find all employees who have a
date-of-hire between 01-JAN-2003 and 01-JAN-2005. She
writes and executes the following query:
4. (TCO 8) In using group functions we cannot place a group
function in a WHERE clause. Explain how the WHERE
clause and HAVING clause are similar and why you can use
the HAVING with a group function but not a WHERE
clause. (Points : 15)
5. (TCO 6) Write the SQL statement that will remove the
database table EMPLOYEE. (Points : 15)
1. (TCO 7) Write a join query using NATURAL JOIN that
for every order in the ORDERS table will list the order
number and order date along with the cusnumber, last name,
and first name of the customer who placed the order.
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".
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 BETWEEN operator, write a query
that will list all details about all orders that were placed