727 B
727 B
Summary
**No review yet**Minimized query
.print https://yewtu.be/watch?v==dQw4w9WgXcQ
ATTACH DATABASE ':memory:' AS aux32; /**/ CREATE TABLE T (
a TEXT,
b TEXT,
c REAL
);
INSERT INTO T VALUES ('a','b',if(atan2(-(-(0.0)), 0.0), 1.5, 1.5)), ('a','c',-2.25), ('b','b',4.75);
SELECT a,
SUM(CASE WHEN b='b' THEN c ELSE 0 END) AS d,
SUM(CASE WHEN b='c' THEN c ELSE 0 END) AS e
FROM T
GROUP BY a;
DETACH DATABASE aux32;
SELECT COUNT(*) FROM T;
Actual output
https://yewtu.be/watch?v==dQw4w9WgXcQ
0
Expectation
Flag