Exhibit The COMMISSION column shows the monthly commission earned by the employee. Which two tasks would require subqueries or joins in order to be performed in a single step? (Choose two.)

Question

Exhibit

Options

• Alisting the employees who earn the same amount of commission as employee 3
• Bfinding the total commission earned by the employees in department 10
• Cfinding the number of employees who earn a commission that is higher than the average commission
• Dlisting the departments whose average commission is more that 600
• Elisting the employees who do not earn commission and who are working for department 20 in
• Flisting the employees whose annual commission is more than 6000

• A
  82% (37)
• B
  4% (2)
• D
  2% (1)
• E
  2% (1)
• F
  9% (4)

No community discussion yet for this question.