This assignment aims at enhancing your skills of using complex SQL statements to solve more realistic business problems. Work through each section in the SQL queries and subqueries tutorial, pay special attention on how to write statements for joins and use operators such as UNION, INTERSECT, and MINUS.
Oracle SQL Queries and Subqueries
Document your work with screen shots of SQL queries and the results of executing the queries. You are encouraged to come up with your own queries based on what the tutorial has explained.
Submit a 2-5 page summary of your work which discusses your experience. Put this document and the file containing your screen shots into one zip file, and submit it to Coursenet.
Expectations
1. Be able to use advanced SQL statements for data manipulation, in particular, ways of combining data from different tables.
2. Successfully execute SQLs for the desired outcome.