Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.

Select number of movies grouped by year USING MySQL   The Movie table has the following columns: ID - integer, primary key Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer Write a SELECT statement to select the year and the total number of movies for that year. Hint: Use the COUNT() function and GROUP BY clause.

Write a SELECT statement that returns one row for each customer that has orders with these columns: The email_address from the Customers table A count of the number of orders The total amount for each order (Hint: First, subtract the discount amount from the price. Then, multiply by the quantity.) Return only those rows where the customer has more than 1 order. Sort the result set in descending sequence by the sum of the line item amounts.     everytime l try to write this sql statement an error occurs

Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created on November 15, 2021. Task 13: List the invoice number and invoice date for each invoice created for the customer James Gonzalez. Task 15: List the invoice number and invoice date for each invoice that either was created for James Gonzalez or that contains an invoice line for Wild Bird Food (25lb).   TEMPLATE -- Task # 6SELECT CUSTOMER.CUST_ID, FIRST_NAME, LAST_NAMEFROM _____________, _________________WHERE CUSTOMER.________________ = ______________.CUST_IDAND INVOICES.____________________ <> '2021-11-15'; -- Task # 13SELECT INVOICE_NUM, INVOICE_DATEFROM ______________WHERE ____________ IN (SELECT CUST_ID FROM CUSTOMER WHERE _____________ = _______________AND ____________ = ______________); -- Task # 15SELECT DISTINCT INVOICES.INVOICE_NUM, INVOICES.INVOICE_DATEFROM INVOICES, INVOICE_LINE, ITEM, CUSTOMERWHERE INVOICES.INVOICE_NUM = INVOICE_LINE.INVOICE_NUMAND INVOICE_LINE.ITEM_ID =…