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

1. Show id, orderdate, shipdate, and paiddate from ORDERS table. (25 points)
2. Show the above for customer(s) only handled by a specific sales representative. (30 points)
3. The last name of the sales reps is "Pratt". (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. There will be a total of six (6) rows selected.

Create a single SQL script for the project (10 points off if not in one file).  Submit your project through Dropbox in D2L. 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, 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_project2.sql, where firstname and lastname are your first and last name, respectively, and "_" is underscore.

Please note that five (5) points will be taken for all projects this semester from this point on if the file naming convention is not followed.

 

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