SELECT department_id, AVG(salary) FROM employees WHERE commission_pct <> "null" GROUP BY department_id
Tampilkan gaji rata -rata karyawan untuk setiap departemen yang mendapat persentase komisi.
CREATE TABLE employees (department_id VARCHAR, salary INTEGER, commission_pct VARCHAR)