select all the correct answers and walk me through your thought process

You have.been asked to list the timecard_id, employee_id, and normal_hours for all employees in the "Sales" department. Which of these queries satisfies this request? SELECT timecard_id, employee_id, normal_hours FROM timecard WHERE employee_id = (SELECT * FROM employee WHERE department = 'Sales') SELECT timecard_id, employee_id, normal_hours FROM timecard WHERE employee_id = (SELECT employee_id FROM employee WHERE department = 'Sales') SELECT timecard_id, employee_id, normal_hours FROM timecard WHERE employee_id IN (SELECT employee_id FROM employee WHERE department ='Sales') SELECT tc.timecard_id, tc.employee_id, tc.normal_hours FROM employee AS emp JOIN timecard AS tc ON emp.department = 'Sales' SELECT tc.timecard_id, tc.employee_id, tc.normal_hours FROM timecard AS tc JOIN employee AS emp on tc.employee_id = emp.employee_id WHERE emp.department = 'Sales