Write a query to display the customer code, first name, last name, and sum of all invoice totals for customers with cumulative invoice totals greater than $1,500. Sort the output by the sum of invoice totals in descendingorder.
Answer to relevant QuestionsWrite a query to display the department number, department name, department phone number, employee number, and last name of each department manager. Sort the output by departmentname.What is a correlated subquery? Give an example.What is a stored procedure, and why is it particularly useful? Give an example.Insert the data into the tables you created in Problem1.Write a procedure to delete an invoice given the invoice number as a parameter. Name the procedure prc_inv_delete. Test the procedure by deleting invoices 8005 and 8006.
Post your question