Stored procedure. Please create the following stored routines using CPS3740_2017S database using the tables in dreamhome database. xxxx is your email id

1) Implement a stored procedure p3Q21_xxxx to display the Branch city name that the street contains a given string.

1a) Write a sql statement to run your program with a parameter 'Hall' and its output

2) Implementa stored function f3Q22_xxxx that will return the total number of room that has the price less than a given number. if the input room price is a negative number, please return a null value

2a) Write a sql statement to run your program with an input price 50 and its output on here.

3) Implement a stored function f3Q23_xxxx that will take an input number and return the sum of all odd numbers that are greater than 0 and less that an equal to the input number.

3a) Write the sql statement to run your program with an input number 9 and its output on here.