The following SQL statements create a table type and an inline table-valued function to retrieve information of multiple employees. Please write SQL statements to retrieve information of employees with SSN '123456789', '987987987', and '987654321'.

create type EMP_TYPE as table (

SSN char(9) primary key

);

GO

create function fgetEmp

(

@emps EMP_TYPE READONLY

)

RETURNS TABLE

AS

return (select * from Employee where ssn in (select SSN from @emps))

GO