IBM
C2090-610 · Question #127
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?
The correct answer is D. SELECT employees.name, sales.revenue. See the full explanation below for the reasoning.
Question
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?
Options
- ASELECT employees.name, sales.revenue
- BSELECT employees.name, sales.revenue
- CSELECT employees.name, sales.revenue
- DSELECT employees.name, sales.revenue
How the community answered
(29 responses)- A14% (4)
- B3% (1)
- C3% (1)
- D79% (23)
Community Discussion
No community discussion yet for this question.