The EMPLOYEES table contains these columns: You need t

单项选择题

The EMPLOYEES table contains these columns:

You need to write a query that will produce these results:
1. Display the salary multiplied by the commission_pct.
2. Exclude employees with a zero commission_pct.
3. Display a zero for employees with a null commission value.
Evaluate the SQL statement:

What does the statement provide?（）

A. All of the desired results
B. Two of the desired results
C. One of the desired results
D. An error statement

1Z0-007