Is this correct?

Considering the schema at EMPLOYEE ssn fname, Iname, phone, bdate) DEPARTMENT dept-id, dept-name) PROFESSOR ssn title, research-interest) WORKS INC prof-son, dept-id) date-started Which of the following finds the first name and last name of all employees who are professors with the title as 'assistant professor' and first names starting with the letter W. SELECT frame, Iname FROM EMPLOYEE WHERE fname LIKE 'W%' AND ss IN (SELECT ssn FROM PROFESSOR WHERE title = 'assistant professor'); SELECT fname, Iname FROM EMPLOYEE INNER JOIN PROFESSOR ON EMPLOYEE.ssn = PROFESSOR.ssn WHERE fname LIKE "W%" AND title = 'assistant professor'; SELECT fname, Iname FROM EMPLOYEE WHERE fname LIKE 'W%' AND ssn = (SELECT ssn FROM PROFESSOR WHERE title = 'assistant professor'); SELECT fname, Iname FROM EMPLOYEE WHERE fname LIKE 'W%' AND ssn = (SELECT ssn FROM EMPLOYEE WHERE title = 'assistant professor')