Which FROM clause should be used to list the dates of orders by employees with the first name 'John'?Select one:

a. FROM orders o JOIN employees e ON o.employee_id = e.id

b. FROM orders o JOIN employees e ON o.employee_id = e.id JOIN Order_details od ON od.Order_ID= o.id 

c. FROM orders o JOIN employees e ON o.employee_id = e.id JOIN OrderItem oi ON oi.ProductId = p.ProductId 

d. FROM orders o JOIN employees e ON o.employee_id = e.id JOIN Order_details od ON od.Order_ID= o.order_id