Develop and test at least ten SQL queries using the JOIN syntax discussed in class. At least four of your queries should involve aggregation. To receive full credit, you should use all JOIN variations discussed in class (ON, USING, NATURAL, OUTER) and aggregation with and without GROUP BY clause. Please, generate a script file called query5.sql with all of your join and aggregation queries. Your queries must not produce empty results and also must complete in a reasonable amount of time (a few seconds at most). If any of your queries takes a long time to complete, consider modifying it by adding more conditions that limit the size of the intermediate results or final result.
Develop and test at least two views and at least four queries that use the views. Please, generate a script file called view5.sql with all of your view definitions and queries.
Please, create a new directory in your project directory on the CS server called hw5 and move query5.sql and view5.sql there. Also, please, include the files and data directory that you used to create and populate your database: create_db.sql and populate_db.sql as well as data directory with all data files referenced by create_db.sql. Please make sure that all of the relevant files and no others are in that directory.
The instructions on how to submit your project can be found here.
The due date for the SQL lab is 4:59pm on Thursday, May 8, 2014.