The following SQL statements were executed in sequence:
CREATE DISTINCT TYPE salary AS decimal(7,2) WITH COMPARISONS;
CREATE TABLE staffsalary(empid INT, empsalary salary);
INSERT INTO staffsalary VALUES (10, 50000), (20, 50000.00);
UPDATE staffsalary SET empsalary = 60000
WHERE salary(50000) = empsalary;
What is the current content of the staffsalary table?

A.
ID | EMPSALARY —————– 10 | 60000 20 | 50000.00 —————–
B.
ID | EMPSALARY —————– 10 | 50000.00 20 | 50000.00 —————–
C.
ID | EMPSALARY —————– 10 | 60000.00 20 | 60000.00 —————–
D.
ID | EMPSALARY —————– 10 | 60000.00 20 | 50000.00 —————–
Updates both salary 50000 to 60000
0
0