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.