0
What is the output of the following SQL statements?
CREATE TABLE t(v INT);
INSERT INTO t VALUES (3),(8),(5),(10);
UPDATE t SET v = CASE WHEN v > 5 THEN v - 5 ELSE v + 5 END;
SELECT SUM(v) FROM t;- A18
- B21
- C31
- D26
Correct answer: D
What is the output of the following SQL statements?
CREATE TABLE t(v INT);
INSERT INTO t VALUES (3),(8),(5),(10);
UPDATE t SET v = CASE WHEN v > 5 THEN v - 5 ELSE v + 5 END;
SELECT SUM(v) FROM t;