Your assignment for this project is to generate an internal sales report using table-join. Your mission is to track which customers have paid their orders. In terms of database operation, your specific tasks are as follows:

1. List in one report (query) to include id, firstname, lastname from CUSTOMERS table, and orderdate, shipdate, paiddate from ORDERS table. (30 points)
   
   
2. You will use a table join to create a single table for reporting purpose. In other words, you will join the CUSTOMERS and ORDERS tables. (45 points)
   
   
3. Rearrange the results by in ascending order according to "paiddate". (15 points)

 

Tips:

1. You will need to use the script "chap04.sql" for this project, in a similar way to what you have worked at chapter 4 of the course web site.
   
   
2. The SQL commond of "DESC tablename" is useful when you want to know the table structure. For example, if you want to know the colunm names of ORDERS table, you may use "DESC ORDERS" in SQL Plus.
   
   
3. Please pay attention to the logic relation between tables. For example, the ID in ORDERS table is not the same as ID in CUSTOMERS table.
   
   
4. Please note "natural join" is very dangerous if you do not fully understand it, which may produce wrong results without knowing. You really have to know what it does before you can use it. In this particular case, you cannot use "natural join" for this project.

.