SLPRS CUSTOMER SLPRS SLPRS FNAME SLPRS LNAME SLPRS TELEPHONE SLPRS HIRE DATE CUST TITLE CUST TELEPHONE CUST ADDRESS CUST CITY CUST STATE CUST PC Lead Lead ID SLPRS ID Customer ID Date Expected date Amount Possibility Status 1. Using the script editor, create a trigger named LEAD_TRG that will increase all possibilities by 5% after a new record is inserted into table leads. 2. Using the ROUND function create an SQL query that will group lead amount in 1000s and count them 3. Repeat exercise (3) using the FLOOR function and group amounts in 500s 4. Write an SQL query that will display the saleperson's names as (example Jessica Aldo as Je_ALD) 5. Write an SQL query that will lead list all leads with expected day 700 days before today SLPRS CUSTOMER SLPRS SLPRS FNAME SLPRS LNAME SLPRS TELEPHONE SLPRS HIRE DATE CUST TITLE CUST TELEPHONE CUST ADDRESS CUST CITY CUST STATE CUST PC Lead Lead ID SLPRS ID Customer ID Date Expected date Amount Possibility Status 1. Using the script editor, create a trigger named LEAD_TRG that will increase all possibilities by 5% after a new record is inserted into table leads. 2. Using the ROUND function create an SQL query that will group lead amount in 1000s and count them 3. Repeat exercise (3) using the FLOOR function and group amounts in 500s 4. Write an SQL query that will display the saleperson's names as (example Jessica Aldo as Je_ALD) 5. Write an SQL query that will lead list all leads with expected day 700 days before today