Given the following table:
CURRENT_EMPLOYEES
————————–
EMPID INTEGER NOT NULL
NAME CHAR(20)
SALARY DECIMAL(10,2)
PAST_EMPLOYEES
————————–
EMPID INTEGER NOT NULL
NAME CHAR(20)
SALARY DECIMAL(10,2)
Assuming both tables contain data, which of the following statements will NOT successfully add
data to table CURRENT_EMPLOYEES?

A.
INSERT INTOcurrent_employees (empid) VALUES (10)

B.
INSERT INTOcurrent_employees VALUES (10, ‘JAGGER’, 85000.00)

C.
INSERT INTOcurrent_employees SELECT empid, name, salary FROM past_employees
WHERE empid = 20

D.
INSERT INTOcurrent_employees (name, salary) VALUES (SELECT name, salary FROM
past_employees WHERE empid = 20)