There are 19 questions listed below. Based on the content in the M06 Readings, answer each question. After completing, save and execute your scripts in Oracle Application Express. Upload a copy of each of your scripts to IvyLearn.

• M06_LastNameFirstName_Queries
• M06_LastNameFirstName_Joins

*Note: For your statements to work, you will need to execute the scripts provided with this assignment. To help with identifying tables that are needed, the ERD of the Academic Database has been included on the very last page of this activity.

(2 points each) Create the SQL statements for displaying the results for each of the following scenarios in the Academic Database. Save these statements in a script called M06_LastNameFirstName_ Queries (where LastName is your last name and FirstName is your first name). Run/execute these commands in Oracle Application Express. Based on data in the Academic Database, complete the following:

1. Write a simple query to view the data inserted in student table created for the Academic Database.
2. Display the First Name and Email Address as "The email address of is ".
3. Display the department name and the HOD of the department from the Department table.
4. Display the distinct Department ID from the Course table.
5. Display the course details for the Spring Session (Session ID 100).
6. Display the details of the students who have scored more than 93.
7. Display the course details for departments 20 and 30.
8. Display the details of students whose first name begins with the letter "M".
9. Display the details of students who have opted for courses 190 or 193.
10. Display the course details offered by department 30 for the Fall Session (Session ID 200).

(2 points each) Create the SQL statements for displaying the results for each of the following scenarios in the Academic Database. Save these statements in a script called M06_LastNameFirstName_Joins (where LastName is your last name and FirstName is your first name). Run/execute these commands in Oracle Application Express. To help with identifying tables that are needed to do joins, the ERD of the Academic Database has been included on the very last page of this activity. Based on the data given (shown below) for the Academic Database, complete the following:

13. Display the name of courses offered and the name of each session it is offered in.
14. Display the name of courses offered in the Fall session.
15. Display the course details and students who have enrolled for those courses.
16. Display the course details and students who have enrolled for those courses for department 30.
17. Will the given statement execute successfully? If not, what must be changed? Explain your answer in a comment in your script. Make the appropriate changes and include in the script.