http://www.quia.com/quiz/1735036.html part 1

http://www.quia.com/quiz/1748007.html part 2

http://awads.net/wp/2006/03/20/back-to-basics-inner-joins/

http://www.databasejournal.com/features/oracle/article.php/3527921

Ilearining Section 5 Lesson 4
Discuss in class.

Try and Solve it 1-10

Tables needed.

1. Create a query that will show the average cost of the DJ on Demand events. Round to two decimal places.
d_events;

2. Find the average salary for Global Fast Foods staff members whose manager ID is 19.
f_staffs
manager_id3.

3. Find the sum of the salaries for Global Fast Foods staff members whose IDs are 12 and 9.

f_staffs

4. Using the Oracle database, select the lowest salary, the most recent hire date, the last name of the person who is at the top of an alphabetical list of employees, and the last name of the person who is at the bottom of an alphabetical list of employees. Select only employees who are in departments 50 or 60.
department_id

5. Your new Internet business has had a good year financially. You have had 1,289 orders this year. Your customer order table has a column named total_sales. If you submit the following query, how many rows will be returned?
SELECT sum(total_sales)
FROM orders;

6. You were asked to create a report of the average salaries for all employees in each division of the company. Some employees in your company are paid hourly instead of by salary. When you ran the report, it seemed as though the averages were not what you expected. They were much higher than you thought! What could have been the cause?

7. Employees of Global Fast Foods have birth dates of July 1, 1980, March 19, 1979, and March 30, 1969. If you select MIN(birthdate), which date will be returned?

8. Create a query that will return the average order total for all Global Fast Foods orders from January 1, 2002, to December 21, 2002.
f_orders

9. What was the hire date of the last Oracle employee hired?
employees

10. In the following SELECT clause, which value returned by the SELECT statement will be larger?
SELECT SUM(operating_cost), AVG(operating_cost)

http://www.adp-gmbh.ch/ora/sql/

usfl_nhs_sql01_xx
http://ilearning.oracle.com/

usfl_nhs
usfl_nhs_sql01_sXX

https://iacademy.oracle.com/