Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS t1;
- CREATE TABLE IF NOT EXISTS t1 (
- b BOOLEAN,
- i INTEGER,
- x INTEGER
- );
- INSERT INTO t1 (i, x, b) VALUES (1 ,2, false), (2, 3, true), (3, 5, false), (1, 7, false), (2, 11, true), (3, 13, true), (1, 17, false), (2, 19, true), (3, 23, true), (1, 29, true), (2, 31, false), (3, 37, false);
- SELECT i, sum(x) as sumX, count(b) as cntB FROM (
- SELECT * FROM t1) as tt
- GROUP BY i;
- SELECT i FROM (
- SELECT i, sum(x) as sumX FROM t1 GROUP BY i) as tt
- ORDER BY sumX;
- SELECT sqrt(i), sumX FROM (
- SELECT * FROM (
- SELECT i, sum(x) as sumX FROM t1 GROUP BY i) as tt
- ORDER BY sumX) as ttt
- ORDER BY sqrt(i);
- ## Failing
- SELECT i FROM (
- SELECT i, sum(x) as sumX, count(b) as cntB FROM t1 GROUP BY i) as tt
- WHERE sumX > 60;
- SELECT i FROM (
- SELECT i, b FROM t1 GROUP BY i, b) as tt
- GROUP BY i;
- SELECT i, avg(x) as avgX FROM (
- SELECT * from t1 WHERE b = true ORDER BY x) as tt
- GROUP BY i;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement