Problem Statement

Subquery to List Orders Handled by the Employee Serving Customer 1234 Two tables are given: Employee(eid, name, city) Orders(ord_no, purch_amt, ord_date, customer_id, eid) Which of the following is the correct query to find all the orders handled by the employee who works for the customer whose id is 1234?