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