Write a stored procedure called array_date that takes in as input up to 31numbers in an array - and - an array of up to 12 numbers and then returns the day of the week for each day in the first array for each month in the second 31 numbers array. 

second array. 

For instance: If I call array_date([1, 5, 7], [2, 4]) the output would be:

 numbers array Tuesday, February 1, 2022

Saturday, February 5, 2022

Monday, February 7, 2022

Friday, April 1, 2022

Tuesday, April 5, 2022

Thursday, April 7, 2022

2. Write a stored procedure called name_fun which will go through eachlast_name in the employees table and do the following:- If the name starts with a vowel - ignore the name (use CASE function)- If the name does not being with a vowel - replace all vowels in the name with a '*'- Right pad each name with a '+' so that each name printed as 15 characters in total

Example: Adamson - would be ignoredSmith - would become Sm*th++++++++++

For the purposes of this assignment the vowels are: a, e, I, o, u