Write the code for the following triggers in MySQL, PL/SQL, or T-SQL following the style shown in the text. a. When adding a customer, add the customer’s balance multiplied by the sales rep’s commission rate to the commission for the corresponding sales rep. b. When updating a customer, add the difference between the new balance and the old balance multiplied by the sales rep’s commission rate to the commission for the corresponding sales rep. c. When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.

The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all movies.   Press the Run button to produce a result table. Verify the result table displays five movies. Modify the SELECT statement to only select movies released after October 31, 2015: SELECT*FROM Movie WHERE ReleaseDate >'2015-10-31'; Then run the SQL again and verify the new query returns only three movies, all with release dates after October 31, 2015.   CREATE TABLE Movie (  ID INT,  Title VARCHAR(100),  Rating VARCHAR(5),  ReleaseDate DATE); INSERT INTO Movie VALUES  (1, 'Rogue One: A Star Wars Story', 'PG-13', '2016-12-10'),  (2, 'Hidden Figures', 'PG', '2017-01-06'),  (3, 'Toy Story', 'G', '1995-11-22'),  (4, 'Avengers: Endgame', 'PG-13', '2019-04-26'),  (5, 'The Godfather', 'R', '1972-03-14'); -- Modify the SELECT statement:SELECT *FROM Movie;Where ReleaseDate > '2015-10-31';

2. Write a SQL statement to insert a new user with userId ‘XXXXX’ into the users table and populate at least 5 other columns including column userName. Note: userName column is varchar(20) and its value must be unique in the table users. DO NOT insert into the “created” column but pay attention to it’s value after the insert Paste the SQL below.

Database  Q1: Select the correct SQL statement to provide the user Samer with read only permission on Employees table a) Grant read on Employee where username = Samer; b) Grant read only on Employee to Samer; c) Grant select to Samer on Employee; d) Grant select on Employee to Samer; Q2: Based on the TWO schema structures below, which SQL statement will create a view to show department names where each department has at least 5 employees? Employee (E_ID, E_Name, D_ID, E_Salary) Department (D_ID, D_Name, D_Address) (Select one) a) Create View Dept_Emp as select D_Name, count(E_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Where count (E_ID) >= 5; b) Create View Dept_Emp as select D_Name, count(E_ID) from Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; c) Create View Dept_Emp as select D_Name, count(D_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; d)…