Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all
employees and their associated revenue, even if no revenue exists. Which SQL statement
will produce the desired list?

A.
SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON
employees.id = sales.emp_id

B.
SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON
sales.emp_id = employees.id

C.
SELECT employees.name, sales.revenue FROM sales LEFT OUTER JOIN employees
ON employees.id = sales.emp_id

D.
SELECT employees.name, sales.revenue FROM sales RIGHT OUTER JOIN employees
ON employees.id = sales.emp_id