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

Answer rating: 100% (QA)

The detailed answer for the above question is provided below To list the dates of orders by emplo... View the full answer