Import sales$\_$tax$\_$rate.sql and sales$\_$tax$\_$rate.txt $[$from week$-1]$ to create the tables and data in your database$\mathrm{.}2.$Write a procedure $($name the procedure as tax$\_$increase$\_$yourFirstName$)$ 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 student number; if it is $2,$ increase the tax rate by $2\%.$ If the last digit is $9$ for another student, then increase tax by $9\%$ and so on$\mathrm{.}43.$After completing the coding task, export the code for submission$\mathrm{.}4$Add your name and student number at the top of the code file as a comment.Put necessary comments to explain your code inside the $.$sql file$\mathrm{.}1$Part$-2$NoTaskMark$($s$)/51.$Import Canadian$\_$pt$.$sql file to create the table in the database you created$2.$Write a trigger $($name the trigger as capt$\_$yourFirstName$)$ 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',$\text{'}$nb$\text{'}),(5,$'Manitoba',$\text{'}$mb$\text{'}),(6,$'British Columbia',$\text{'}$bc$\text{'}),(7,$'Prince Edward Island',$\text{'}$pe$\text{'}),43.$After completing the coding task, export the code for submission$\mathrm{.}4$Add your name and student number at the top of the code file as a comment.Put necessary comments to explain your code inside the $.$sql file.