Question

Select the suitable option for displaying the average commission percentage of all employees, where the commission percentage column of certain employees include null value. Select one:

Answer 1

Explanation:

Select all data from the DEPARTMENTS table. ... Create a query to display all the data from the EMPLOYEES table. .... to display the last name, salary, and commission for all .

Answer 2

Answer:

The query is generated.

Explanation:

Given: Table of employee data

To find: Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

Query 1

SELECT last_name, department_id, salary FROM employees

WHERE (salary, department_id) IN (SELECT salary, department_id

FROM employees WHERE commission_pct IS NOT NULL);