You will need to use the script "chap04.sql" for this project, in a similar way to what you have worked at the text on the course web site. Your assignment for this project is to use subqueries to accomplish the following tasks:

1. Show c_id, orderdate, shipdate, and paiddate from ORDERS table. The "c_id" is a column for customer ID. (25 points)
2. Show the above for customers only handled by two sales representatives. (30 points)
3. The last names of the two sales reps are "Jonah" and "Greenberg." (30 points)
4. Rearrange the results in ascending order according to orderdate. (15 points)

Tips:

1. You will need to query three tables (orders, customers, and salesreps).
2. Please note that case is important within quotes in Oracle. For example, 'Peter' is different from 'peter'.

 

Submit your project through WebCT. If you need instructions on how to submit, click here.

Please submit your SQL script only. SQL script is in .sql format, which can be run in Oracle SQL Plus as SQL>@filepath\file.sql. For example, if your SQL script is saved as myscript.sql in the directory of "C:\temp\", then we will be able to execute it in SQL Plus as "SQL>@C:\temp\myscript.sql."

Convention for File Name: Please name your file as firstname_lastname_project3.sql, where firstname and lastname are your first and last name, respectively, and "_" is an underscore.

Please note: Five (5) points will be taken off if the file convention is not followed.

At the end of this week. Please see the course schedule for exact due date.