Hello this needs to be done using ORACLE SQL

--============================================ -- DATA BASE OBJECTS -- 60 points (5 points each) --============================================ /* 1. Write the SQL to get the Employee Count by Manager. Your results should include the following details: Manager Employee ID Manager Last Name Manager First Name Manager Department Name (not Department_ID) Manager Job_Title (not Job_ID) Employee Count Sort your results by employee count (descending). HINT: This will require a self-join on HOL_EMPLOYEES, other JOINS, and a sub- query. */ /* 2. Write the SQL to create a view called vManagerEmployeeCount using your query from Q1. Make this view read-only. In a second SQL statement, Select all rows from your view. */ /* 3. Create a SYNONYM for your view named vMEC. Write a separate SQL statement to select all rows from your view using your synonym. */ /* 4. Using your SYNONYM, write a query to display all results from your view. Sort your results be department name. */ /* 5. Using your SYNONYM, write a query to display results from you view where employee count >= 4. Sort results by Manager last and first names. */ /* 6. Write the SQL to create a sequence with following specifications: Name: SEQ_HOL_BOOK_CATEGORY Starting Value: 10 Maximum Value: 10000000 Increment By: 1

*/ /* 7. Write and run an INSERT statement to create a new Book Category named "Drama". Use you SEQ_HOL_BOOK_CATEGORY to generate a value for the PK of this new row. */ /* 8. Modify (do not recreate) the SEQ_HOL_BOOK_CATEGORY so that it increments by 5 and there is no maximum value. */ /* 9. Write the SQL to remove the HOL_DEPARTMENTS_SEQ from the database. This sequence was created in Module 1 or 2. */ /* 10. Write the SQL to create an index named IX_CUST_NAME for the LAST_NAME and FIRST_NAME columns in the HOL_CUSTOMERS table. */ /* 11. What is the benefit of IX_CUST_NAME? */ /* 12. Use APEX Object Browser to find all of the indexes on HOL_EMPLOYEES. Answer these questions. 1. How many Indexes are declared on HOL_EMPLOYEES? 2. What are the names of each of these indexes? 3. Which of these indexes are UNIQUE? 4. Which of these indexes are NONUNIQUE? 5. For each index, what are the column/s the index os based upon? */

DBMS 130: HOL Small Company ERD