None of the above options
Explanation:
SELECT Orders.OrderID, Employees.LastName, Employees.FirstName
FROM Orders
RIGHT JOIN Employees
ON Orders.EmployeeID = Employees.EmployeeID;
This gave the result which is same as option A
but when I executed
SELECT Orders.OrderID, Employees.LastName, Employees.FirstName
FROM Orders
RIGHT JOIN Employees
ON Orders.EmployeeID = Employees.EmployeeID
where Orders.EmployeeID is NULL;
Result had only the records where OrderID was NULL
One can try it on w3schools to get a better understanding.
Also one can refer the following link to get a clear understanding
https://www.dofactory.com/sql/right-outer-join