Which of the following finds the first name and last name10+ of all employees who are professors with the title as 'assistant professor' and first names starting with the letter w. select fname, lname from employee where fname like 'w%' and ssn in ( select ssn from professor where title = 'assistant professor' ); select fname, lname from employee where fname like 'w%' and ssn = (select ssn from professor where title = 'assistant professor'); select fname, lname from employee inner join professor on employee. ssn = professor. ssn where fname like "w%" and title = 'assistant professor'; select fname, lname from employee where fname like 'w%' and ssn = (select ssn from employee where title = 'assistant professor'); all of these none of these