Using Chinook database please if dont have access just provide commands and i can fill in the blanks. thank you.
3.0 SQL Functions In this section you will be using the Oracle system functions, as well as your own functions, to perform various actions against the database 3.1 System Defined Functions Task - Create a function that returns the current time. Task - create a function that returns the length of a mediatype from the mediatype table 3.2 System Defined Aggregate Functions Task -Create a function that returns the average total of all invoices Task - Create a function that returns the most expensive track 3.3 User Defined Scalar Functions Task - Create a function that returns the average price of invoice-line items in the invoice-line table 3.4 User Defined Table Valued Functions Task - Create a function that returns all employees who are born after 1968. 4.0 Stored Procedures In this section you will be creating and executing stored procedures. You will be creating various types of stored procedures that take input and output parameters. 4.1 Basic Stored Procedure Task - Create a stored procedure that selects the first and last names of all the employees. 4.2 Stored Procedure Input Parameters Task - Create a stored procedure that updates the personal information of an employee. Task - Create a stored procedure that returns the managers of an employee 4.3 Stored Procedure Output Parameters Task - Create a stored procedure that returns the name and company of a customer. 5.0 Transactions In this section you will be working with transactions. Transactions are usually nested within a stored procedure. You will also be working with handling errors in your SQL. Task - Create a transaction that given a invoiceld will delete that invoice (There may be constraints that rely on this, find out how to resolve them)...poiij Task - Create a transaction nested within a stored procedure that inserts a new record in the Customer table 3.0 SQL Functions In this section you will be using the Oracle system functions, as well as your own functions, to perform various actions against the database 3.1 System Defined Functions Task - Create a function that returns the current time. Task - create a function that returns the length of a mediatype from the mediatype table 3.2 System Defined Aggregate Functions Task -Create a function that returns the average total of all invoices Task - Create a function that returns the most expensive track 3.3 User Defined Scalar Functions Task - Create a function that returns the average price of invoice-line items in the invoice-line table 3.4 User Defined Table Valued Functions Task - Create a function that returns all employees who are born after 1968. 4.0 Stored Procedures In this section you will be creating and executing stored procedures. You will be creating various types of stored procedures that take input and output parameters. 4.1 Basic Stored Procedure Task - Create a stored procedure that selects the first and last names of all the employees. 4.2 Stored Procedure Input Parameters Task - Create a stored procedure that updates the personal information of an employee. Task - Create a stored procedure that returns the managers of an employee 4.3 Stored Procedure Output Parameters Task - Create a stored procedure that returns the name and company of a customer. 5.0 Transactions In this section you will be working with transactions. Transactions are usually nested within a stored procedure. You will also be working with handling errors in your SQL. Task - Create a transaction that given a invoiceld will delete that invoice (There may be constraints that rely on this, find out how to resolve them)...poiij Task - Create a transaction nested within a stored procedure that inserts a new record in the Customer table
