Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
As a data engineer, your task is to identify employees earning more than USD 500,000 within each department of the company. Given the schema of the company table, which SQL snippet accomplishes this?
A
SELECT department_id,TRANSFORM(employees, e -> e.employee_salary > 500000) as employees_with_high_salary FROM company;
B
SELECT department_id,FETCH(employees, e -> e.employee_salary > 500000) as employees_with_high_salary FROM company;
C
SELECT department_id,EXIST(employees, e -> e.employee_salary > 500000) as employees_with_high_salary FROM company;
D
SELECT department_id,REDUCE(employees, e -> e.employee_salary > 500000) as employees_with_high_salary FROM company;
E
SELECT department_id,FILTER(employees, e -> e.employee_salary > 500000) as employees_with_high_salary FROM company;
