Please I need help with following SQL tasks ;

--4.0 Stored Procedures --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 info 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 --Task - Create a transaction that given a invoiceId will delete that invoice (There may be constraints that rely on this, find out how to resolve them) --Task - Create a transaction nested within a stored procedure that inserts a new record in the customer table

--6.0 Triggers --6.1 AFTER/FOR --Task - Create an after insert trigger on the employee table fired after a new record is inserted into the table --Task - Create an after update trigger on the album table that fires after a row is inserted in the table --Task - Create an after delete trigger on the customer table that fires after a row is deleted from the table

--7.0 JOINS --7.1 INNER --Task - Create an inner join that joins customers and orders and specifies the name of the customer and the invoiceId --7.2 OUTER --Task - Create an outer join that joins the customer and invoice table, specifying the CustomerId, firstname, lastname, invoiceid and total

--7.3 RIGHT --Task - Create a right join that joins album and artist specifying artist name and title

--7.4 CROSS --Task - Create a cross join that joins album and artist and sorts by artist name in ascending order

--7.5 SELF --Task - perfom a self-join on the employee table, joining on the reportsto column

--7.6 Complicated Join Assignment --Task - Create an inner join betweent all tables in the chinook database

--9.0 Administration --Task - Create a .bak file for the chinook database

Thank you so much!!