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.revenueFROM employeesINNER JOIN sales ON employees.id = sales.emp_id
B. SELECT employees.name, sales.revenueFROM employeesINNER JOIN sales ON sales.emp_id = employees.id
C. SELECT employees.name, sales.revenueFROM salesLEFT OUTER JOIN employees ON employees.id = sales.emp_id
D. SELECT employees.name, sales.revenueFROM salesRIGHT OUTER JOIN employees ON employees.id = sales.emp_id
|
Download Printable PDF. VALID exam to help you PASS. |
 |