Examine this data in the EMPLOYEES table: Which statement will execute successfully?

Question

Exhibit

Options

• ASELECT dept_id, INSTR(last_name, `A'), SUM(salary) FROM employees GROUP BY dept_id;
• BSELECT dept_id, STDDEV(last_name), SUM(salary) FROM employees GROUP BY dept_id;
• CSELECT dept_id, MAX(last_name), SUM(salary) FROM employees GROUP BY dept_id;
• DSELECT dept_id, LENGTH(last_name), SUM(salary) FROM employees GROUP BY dept_id;

• A
  3% (1)
• B
  3% (1)
• C
  86% (25)
• D
  7% (2)

No community discussion yet for this question.