SQL Programming 1. create a table-valued function named fnEmployeeBirthDaysPP. This function requires one parameters of

[answerhappygod]

SQL Programming
1. create a table-valued function named fnEmployeeBirthDaysPP. This function requires one parameters of data type INT. Do not validate the input parameter. Have the functionreturn a result set that consists of the LastName, FirstName, andBirthDate for each active employee (employee that has not beenreleased) that has a birthdate in the month specified by theparameter value passed to the function. For example:
If a 0 is passed to the function, the function is to return anempty result set.
if a 1 is passed to the function, it is to return the LastName,FirstName, and BirthDate of each active employee born inJanuary.
if a 2 is passed to the function, it is to return the LastName,FirstName, and BirthDate of each active employee born inFebruary.
- Paste below this line the code you wrote to create thefnEmployeeBirthDaysXX function
1.2 Test the Function you created for exercise one by coding andexecuting a select statement that invokes the function from withina SELECT statement to return the data for active employees born inJuly.
--- Paste below this line the Select statement you wroteto test the fnEmployeeBirthDayXX function