1
DROP TABLE IF EXISTS t1;
2
DROP TABLE IF EXISTS t2;
3
CREATE TABLE t1 (c1 INT, c2 CHAR(100),c3 FLOAT);
4
INSERT INTO t1 VALUES (null,null,0.0);
5
INSERT INTO t1 VALUES (1,'',1.0);
6
INSERT INTO t1 VALUES (2,'abcde',2.0);
7
INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
8
CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
9
INSERT INTO t2 VALUES (1,'abcde');
10
INSERT INTO t2 VALUES (2,'abcde');
11
SELECT sb1,sb2,sb3 FROM (SELECT c1 AS sb1, c2 AS sb2, c3*2 AS sb3
12
FROM t1) AS sb WHERE sb1 > 1;
16
SELECT AVG(sum_column1) FROM (SELECT SUM(c1) AS sum_column1 FROM t1
22
CREATE TABLE t1 (c1 INT, c2 VARCHAR(100),c3 FLOAT);
23
INSERT INTO t1 VALUES (null,null,0.0);
24
INSERT INTO t1 VALUES (1,'',1.0);
25
INSERT INTO t1 VALUES (2,'abcde',2.0);
26
INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
27
CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
28
INSERT INTO t2 VALUES (1,'abcde');
29
INSERT INTO t2 VALUES (2,'abcde');
30
SELECT sb1,sb2,sb3 FROM (SELECT c1 AS sb1, c2 AS sb2, c3*2 AS sb3
31
FROM t1) AS sb WHERE sb1 > 1;
35
SELECT AVG(sum_column1) FROM (SELECT SUM(c1) AS sum_column1 FROM t1
41
CREATE TABLE t1 (c1 INT, c2 BINARY(100),c3 FLOAT);
42
INSERT INTO t1 VALUES (null,null,0.0);
43
INSERT INTO t1 VALUES (1,'',1.0);
44
INSERT INTO t1 VALUES (2,'abcde',2.0);
45
INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
46
CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
47
INSERT INTO t2 VALUES (1,'abcde');
48
INSERT INTO t2 VALUES (2,'abcde');
49
SELECT sb1,sb2,sb3 FROM (SELECT c1 AS sb1, c2 AS sb2, c3*2 AS sb3
50
FROM t1) AS sb WHERE sb1 > 1;
54
SELECT AVG(sum_column1) FROM (SELECT SUM(c1) AS sum_column1 FROM t1
60
CREATE TABLE t1 (c1 INT, c2 VARBINARY(100),c3 FLOAT);
61
INSERT INTO t1 VALUES (null,null,0.0);
62
INSERT INTO t1 VALUES (1,'',1.0);
63
INSERT INTO t1 VALUES (2,'abcde',2.0);
64
INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
65
CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
66
INSERT INTO t2 VALUES (1,'abcde');
67
INSERT INTO t2 VALUES (2,'abcde');
68
SELECT sb1,sb2,sb3 FROM (SELECT c1 AS sb1, c2 AS sb2, c3*2 AS sb3
69
FROM t1) AS sb WHERE sb1 > 1;
73
SELECT AVG(sum_column1) FROM (SELECT SUM(c1) AS sum_column1 FROM t1