1. Write a SQL procedure to increase the sales tax to a certain percentage, and the states' names started with the letter A. Please find the last digit of your phone number; if it is 4, increase the tax rate by 4%. If the last digit is 5 for another student, then increase tax by 5% and so on.

2. Write a sql trigger to ensure the upper case of the provincial or territorial iso code/shortcode. Another way is if someone gives input ON as on, the trigger will turn the input to ON. Try the following values to ensure the trigger is working (4,'New Brunswick', 'nb'), (5,'Manitoba', 'mb'), (6,'British Columbia','bc'), (7,'Prince Edward Island','pe')