2
DROP TABLE IF EXISTS t1;
5
DROP TABLE IF EXISTS t2;
7
CREATE TABLE t1 (c1 INT, c2 CHAR(100));
8
INSERT INTO t1 VALUES (null,null);
9
INSERT INTO t1 VALUES (1,'');
10
INSERT INTO t1 VALUES (2,'abcde');
11
INSERT INTO t1 VALUES (100,'abcdefghij');
12
CREATE TABLE t2 (c1 INT);
13
INSERT INTO t2 VALUES (null);
14
INSERT INTO t2 VALUES (2);
15
INSERT INTO t2 VALUES (100);
16
SELECT (SELECT AVG(c1) FROM t1);
17
SELECT (SELECT MIN(c1) FROM t2) FROM t1;
18
SELECT UPPER((SELECT c2 FROM t1 WHERE c1=2)) FROM t2;
19
SELECT c1 FROM t1 WHERE c1 = (SELECT MAX(c1) FROM t2);
20
SELECT c1 FROM t1 AS t WHERE 4 = (SELECT COUNT(*) FROM t1 WHERE
24
CREATE TABLE t1 (c1 INT, c2 VARCHAR(100));
25
INSERT INTO t1 VALUES (null,null);
26
INSERT INTO t1 VALUES (1,'');
27
INSERT INTO t1 VALUES (2,'abcde');
28
INSERT INTO t1 VALUES (100,'abcdefghij');
29
CREATE TABLE t2 (c1 INT);
30
INSERT INTO t2 VALUES (null);
31
INSERT INTO t2 VALUES (2);
32
INSERT INTO t2 VALUES (100);
33
SELECT (SELECT AVG(c1) FROM t1);
34
SELECT (SELECT MIN(c1) FROM t2) FROM t1;
35
SELECT UPPER((SELECT c2 FROM t1 WHERE c1=2)) FROM t2;
36
SELECT c1 FROM t1 WHERE c1 = (SELECT MAX(c1) FROM t2);
37
SELECT c1 FROM t1 AS t WHERE 4 = (SELECT COUNT(*) FROM t1 WHERE
41
CREATE TABLE t1 (c1 INT, c2 BINARY(100));
42
INSERT INTO t1 VALUES (null,null);
43
INSERT INTO t1 VALUES (1,'');
44
INSERT INTO t1 VALUES (2,'abcde');
45
INSERT INTO t1 VALUES (100,'abcdefghij');
46
CREATE TABLE t2 (c1 INT);
47
INSERT INTO t2 VALUES (null);
48
INSERT INTO t2 VALUES (2);
49
INSERT INTO t2 VALUES (100);
50
SELECT (SELECT AVG(c1) FROM t1);
51
SELECT (SELECT MIN(c1) FROM t2) FROM t1;
52
SELECT UPPER((SELECT c2 FROM t1 WHERE c1=2)) FROM t2;
53
SELECT c1 FROM t1 WHERE c1 = (SELECT MAX(c1) FROM t2);
54
SELECT c1 FROM t1 AS t WHERE 4 = (SELECT COUNT(*) FROM t1 WHERE
58
CREATE TABLE t1 (c1 INT, c2 VARBINARY(100));
59
INSERT INTO t1 VALUES (null,null);
60
INSERT INTO t1 VALUES (1,'');
61
INSERT INTO t1 VALUES (2,'abcde');
62
INSERT INTO t1 VALUES (100,'abcdefghij');
63
CREATE TABLE t2 (c1 INT);
64
INSERT INTO t2 VALUES (null);
65
INSERT INTO t2 VALUES (2);
66
INSERT INTO t2 VALUES (100);
67
SELECT (SELECT AVG(c1) FROM t1);
68
SELECT (SELECT MIN(c1) FROM t2) FROM t1;
69
SELECT UPPER((SELECT c2 FROM t1 WHERE c1=2)) FROM t2;
70
SELECT c1 FROM t1 WHERE c1 = (SELECT MAX(c1) FROM t2);
71
SELECT c1 FROM t1 AS t WHERE 4 = (SELECT COUNT(*) FROM t1 WHERE