SQL problems:

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.

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.

Task Create an inner join that joins customers and orders and specifies the name of the customer and the invoiceId.

Task -- Create an outer join that joins the customer and invoice table, specifying the CustomerId, firstname, lastname, invoiceId, and total.

Task Create a right join that joins album and artist specifying artist name and title.

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

Task Perform a self-join on the employee table, joining on the reportsto column.

List of tables and (columns) EMPLOYEE (EMPLOYEEID, LASTNAME, FIRSTNAME, TITLE, REPORTSTO, BIRTHDATE, HIREDATE, ADDRESS, CITY, STATE, COUNTRY, POSTALCODE, PHONE, FAX, EMAIL)

INVOICE(INVOICEID,CUSTOMERID,INVOICEDATE)

CUSTOMER(CUSTOMERID, (FIRSTNAME, LASTNAME, ORDER)

ALBUM(ALBUMID, TITLE, ARTISTID)

ARTIST(ARTISTID, NAME)

ALBUM(ALBUMID, TITLE, ARTISTID)