Lab
In this assignment, you will use the database you created for Lab Part 5 to write a variety of queries demonstrating your understanding of summary and aggregate queries; set operators, functions and formatting query results.
Business situation
You continue to respond to a variety of request that require you to use the database you created for Lab Part 5 (DDL attached to create the DB).
As you complete each task below, answer the questions that follow. Write all answers to the questions on this document.
1. You will use the tables from Lab Part 5 (DDL attached to create) to complete this assignment. Use the connection you used to complete Lab Part 5 to connect to the Oracle database using SQL Developer.
a. What is the name of the connection you used to connect to the Oracle Database?
2. For each query shown in the screen clipping below, write a question that the return set of the query answers. See the notes at the end of this assignment. Show evidence you successfully ran the queries.
3. Write original seven queries using the database you created for Lab Part 5 (DDL attached). Write one demonstrating your understanding of aggregate functions and set operators: AVE, CUBE ROLLUP, GROUPING, UNION, INTERSECT and MINUS.
a. For each query, write a question that the return set of the query answers in the space below. Place the sql for each query in a file named LabPart6.sql. Include a description of the query in the file.
4. List at least three resources in APA style that you used to complete the tasks in this assignment.
5. List three things that you learned from this assignment.
Attachment:- Lab.rar