0
What is the output of the following SQL statements?
CREATE TABLE m(n TEXT, s INT);
INSERT INTO m VALUES ('a',85),('b',55),('c',70),('d',40);
SELECT SUM(CASE WHEN s >= 60 THEN 1 ELSE 0 END) FROM m;- A2
- B1
- C3
- D4
Correct answer: A
What is the output of the following SQL statements?
CREATE TABLE m(n TEXT, s INT);
INSERT INTO m VALUES ('a',85),('b',55),('c',70),('d',40);
SELECT SUM(CASE WHEN s >= 60 THEN 1 ELSE 0 END) FROM m;