1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 TINYINT NOT NULL);
3
SELECT MAX(c1) AS value FROM t1;
6
SELECT MAX(c1) AS postive_value FROM t1 WHERE c1 > 0;
9
SELECT MAX(c1) AS negative_value FROM t1 WHERE c1 < 0;
12
SELECT MAX(c1) AS zero_value FROM t1 WHERE c1 = 0;
15
SELECT MAX(c1) AS no_results FROM t1 WHERE c1 = 2;
19
CREATE TABLE t1(c1 SMALLINT NOT NULL);
20
SELECT MAX(c1) AS value FROM t1;
23
SELECT MAX(c1) AS postive_value FROM t1 WHERE c1 > 0;
26
SELECT MAX(c1) AS negative_value FROM t1 WHERE c1 < 0;
29
SELECT MAX(c1) AS zero_value FROM t1 WHERE c1 = 0;
32
SELECT MAX(c1) AS no_results FROM t1 WHERE c1 = 2;
36
CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
37
SELECT MAX(c1) AS value FROM t1;
40
SELECT MAX(c1) AS postive_value FROM t1 WHERE c1 > 0;
43
SELECT MAX(c1) AS negative_value FROM t1 WHERE c1 < 0;
46
SELECT MAX(c1) AS zero_value FROM t1 WHERE c1 = 0;
49
SELECT MAX(c1) AS no_results FROM t1 WHERE c1 = 2;
53
CREATE TABLE t1(c1 INT NOT NULL);
54
SELECT MAX(c1) AS value FROM t1;
57
SELECT MAX(c1) AS postive_value FROM t1 WHERE c1 > 0;
60
SELECT MAX(c1) AS negative_value FROM t1 WHERE c1 < 0;
63
SELECT MAX(c1) AS zero_value FROM t1 WHERE c1 = 0;
66
SELECT MAX(c1) AS no_results FROM t1 WHERE c1 = 2;
70
CREATE TABLE t1(c1 INTEGER NOT NULL);
71
SELECT MAX(c1) AS value FROM t1;
74
SELECT MAX(c1) AS postive_value FROM t1 WHERE c1 > 0;
77
SELECT MAX(c1) AS negative_value FROM t1 WHERE c1 < 0;
80
SELECT MAX(c1) AS zero_value FROM t1 WHERE c1 = 0;
83
SELECT MAX(c1) AS no_results FROM t1 WHERE c1 = 2;
87
CREATE TABLE t1(c1 BIGINT NOT NULL);
88
SELECT MAX(c1) AS value FROM t1;
91
SELECT MAX(c1) AS postive_value FROM t1 WHERE c1 > 0;
94
SELECT MAX(c1) AS negative_value FROM t1 WHERE c1 < 0;
97
SELECT MAX(c1) AS zero_value FROM t1 WHERE c1 = 0;
100
SELECT MAX(c1) AS no_results FROM t1 WHERE c1 = 2;
104
CREATE TABLE t1(c1 TINYINT NOT NULL);
105
SELECT MIN(c1) AS value FROM t1;
108
SELECT MIN(c1) AS postive_value FROM t1 WHERE c1 > 0;
111
SELECT MIN(c1) AS negative_value FROM t1 WHERE c1 < 0;
114
SELECT MIN(c1) AS zero_value FROM t1 WHERE c1 = 0;
117
SELECT MIN(c1) AS no_results FROM t1 WHERE c1 = 2;
121
CREATE TABLE t1(c1 SMALLINT NOT NULL);
122
SELECT MIN(c1) AS value FROM t1;
125
SELECT MIN(c1) AS postive_value FROM t1 WHERE c1 > 0;
128
SELECT MIN(c1) AS negative_value FROM t1 WHERE c1 < 0;
131
SELECT MIN(c1) AS zero_value FROM t1 WHERE c1 = 0;
134
SELECT MIN(c1) AS no_results FROM t1 WHERE c1 = 2;
138
CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
139
SELECT MIN(c1) AS value FROM t1;
142
SELECT MIN(c1) AS postive_value FROM t1 WHERE c1 > 0;
145
SELECT MIN(c1) AS negative_value FROM t1 WHERE c1 < 0;
148
SELECT MIN(c1) AS zero_value FROM t1 WHERE c1 = 0;
151
SELECT MIN(c1) AS no_results FROM t1 WHERE c1 = 2;
155
CREATE TABLE t1(c1 INT NOT NULL);
156
SELECT MIN(c1) AS value FROM t1;
159
SELECT MIN(c1) AS postive_value FROM t1 WHERE c1 > 0;
162
SELECT MIN(c1) AS negative_value FROM t1 WHERE c1 < 0;
165
SELECT MIN(c1) AS zero_value FROM t1 WHERE c1 = 0;
168
SELECT MIN(c1) AS no_results FROM t1 WHERE c1 = 2;
172
CREATE TABLE t1(c1 INTEGER NOT NULL);
173
SELECT MIN(c1) AS value FROM t1;
176
SELECT MIN(c1) AS postive_value FROM t1 WHERE c1 > 0;
179
SELECT MIN(c1) AS negative_value FROM t1 WHERE c1 < 0;
182
SELECT MIN(c1) AS zero_value FROM t1 WHERE c1 = 0;
185
SELECT MIN(c1) AS no_results FROM t1 WHERE c1 = 2;
189
CREATE TABLE t1(c1 BIGINT NOT NULL);
190
SELECT MIN(c1) AS value FROM t1;
193
SELECT MIN(c1) AS postive_value FROM t1 WHERE c1 > 0;
196
SELECT MIN(c1) AS negative_value FROM t1 WHERE c1 < 0;
199
SELECT MIN(c1) AS zero_value FROM t1 WHERE c1 = 0;
202
SELECT MIN(c1) AS no_results FROM t1 WHERE c1 = 2;
206
CREATE TABLE t1(c1 TINYINT NOT NULL);
207
SELECT AVG(c1) AS value FROM t1;
210
SELECT AVG(c1) AS postive_value FROM t1 WHERE c1 > 0;
213
SELECT AVG(c1) AS negative_value FROM t1 WHERE c1 < 0;
216
SELECT AVG(c1) AS zero_value FROM t1 WHERE c1 = 0;
219
SELECT AVG(c1) AS no_results FROM t1 WHERE c1 = 2;
223
CREATE TABLE t1(c1 SMALLINT NOT NULL);
224
SELECT AVG(c1) AS value FROM t1;
227
SELECT AVG(c1) AS postive_value FROM t1 WHERE c1 > 0;
230
SELECT AVG(c1) AS negative_value FROM t1 WHERE c1 < 0;
233
SELECT AVG(c1) AS zero_value FROM t1 WHERE c1 = 0;
236
SELECT AVG(c1) AS no_results FROM t1 WHERE c1 = 2;
240
CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
241
SELECT AVG(c1) AS value FROM t1;
244
SELECT AVG(c1) AS postive_value FROM t1 WHERE c1 > 0;
247
SELECT AVG(c1) AS negative_value FROM t1 WHERE c1 < 0;
250
SELECT AVG(c1) AS zero_value FROM t1 WHERE c1 = 0;
253
SELECT AVG(c1) AS no_results FROM t1 WHERE c1 = 2;
257
CREATE TABLE t1(c1 INT NOT NULL);
258
SELECT AVG(c1) AS value FROM t1;
261
SELECT AVG(c1) AS postive_value FROM t1 WHERE c1 > 0;
264
SELECT AVG(c1) AS negative_value FROM t1 WHERE c1 < 0;
267
SELECT AVG(c1) AS zero_value FROM t1 WHERE c1 = 0;
270
SELECT AVG(c1) AS no_results FROM t1 WHERE c1 = 2;
274
CREATE TABLE t1(c1 INTEGER NOT NULL);
275
SELECT AVG(c1) AS value FROM t1;
278
SELECT AVG(c1) AS postive_value FROM t1 WHERE c1 > 0;
281
SELECT AVG(c1) AS negative_value FROM t1 WHERE c1 < 0;
284
SELECT AVG(c1) AS zero_value FROM t1 WHERE c1 = 0;
287
SELECT AVG(c1) AS no_results FROM t1 WHERE c1 = 2;
291
CREATE TABLE t1(c1 BIGINT NOT NULL);
292
SELECT AVG(c1) AS value FROM t1;
295
SELECT AVG(c1) AS postive_value FROM t1 WHERE c1 > 0;
298
SELECT AVG(c1) AS negative_value FROM t1 WHERE c1 < 0;
301
SELECT AVG(c1) AS zero_value FROM t1 WHERE c1 = 0;
304
SELECT AVG(c1) AS no_results FROM t1 WHERE c1 = 2;
308
CREATE TABLE t1(c1 TINYINT NOT NULL);
309
SELECT SUM(c1) AS value FROM t1;
312
SELECT SUM(c1) AS postive_value FROM t1 WHERE c1 > 0;
315
SELECT SUM(c1) AS negative_value FROM t1 WHERE c1 < 0;
318
SELECT SUM(c1) AS zero_value FROM t1 WHERE c1 = 0;
321
SELECT SUM(c1) AS no_results FROM t1 WHERE c1 = 2;
325
CREATE TABLE t1(c1 SMALLINT NOT NULL);
326
SELECT SUM(c1) AS value FROM t1;
329
SELECT SUM(c1) AS postive_value FROM t1 WHERE c1 > 0;
332
SELECT SUM(c1) AS negative_value FROM t1 WHERE c1 < 0;
335
SELECT SUM(c1) AS zero_value FROM t1 WHERE c1 = 0;
338
SELECT SUM(c1) AS no_results FROM t1 WHERE c1 = 2;
342
CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
343
SELECT SUM(c1) AS value FROM t1;
346
SELECT SUM(c1) AS postive_value FROM t1 WHERE c1 > 0;
349
SELECT SUM(c1) AS negative_value FROM t1 WHERE c1 < 0;
352
SELECT SUM(c1) AS zero_value FROM t1 WHERE c1 = 0;
355
SELECT SUM(c1) AS no_results FROM t1 WHERE c1 = 2;
359
CREATE TABLE t1(c1 INT NOT NULL);
360
SELECT SUM(c1) AS value FROM t1;
363
SELECT SUM(c1) AS postive_value FROM t1 WHERE c1 > 0;
366
SELECT SUM(c1) AS negative_value FROM t1 WHERE c1 < 0;
369
SELECT SUM(c1) AS zero_value FROM t1 WHERE c1 = 0;
372
SELECT SUM(c1) AS no_results FROM t1 WHERE c1 = 2;
376
CREATE TABLE t1(c1 INTEGER NOT NULL);
377
SELECT SUM(c1) AS value FROM t1;
380
SELECT SUM(c1) AS postive_value FROM t1 WHERE c1 > 0;
383
SELECT SUM(c1) AS negative_value FROM t1 WHERE c1 < 0;
386
SELECT SUM(c1) AS zero_value FROM t1 WHERE c1 = 0;
389
SELECT SUM(c1) AS no_results FROM t1 WHERE c1 = 2;
393
CREATE TABLE t1(c1 BIGINT NOT NULL);
394
SELECT SUM(c1) AS value FROM t1;
397
SELECT SUM(c1) AS postive_value FROM t1 WHERE c1 > 0;
400
SELECT SUM(c1) AS negative_value FROM t1 WHERE c1 < 0;
403
SELECT SUM(c1) AS zero_value FROM t1 WHERE c1 = 0;
406
SELECT SUM(c1) AS no_results FROM t1 WHERE c1 = 2;
410
CREATE TABLE t1(c1 TINYINT NOT NULL);
411
SELECT COUNT(c1) AS value FROM t1;
414
SELECT COUNT(c1) AS postive_value FROM t1 WHERE c1 > 0;
417
SELECT COUNT(c1) AS negative_value FROM t1 WHERE c1 < 0;
420
SELECT COUNT(c1) AS zero_value FROM t1 WHERE c1 = 0;
423
SELECT COUNT(c1) AS no_results FROM t1 WHERE c1 = 2;
427
CREATE TABLE t1(c1 SMALLINT NOT NULL);
428
SELECT COUNT(c1) AS value FROM t1;
431
SELECT COUNT(c1) AS postive_value FROM t1 WHERE c1 > 0;
434
SELECT COUNT(c1) AS negative_value FROM t1 WHERE c1 < 0;
437
SELECT COUNT(c1) AS zero_value FROM t1 WHERE c1 = 0;
440
SELECT COUNT(c1) AS no_results FROM t1 WHERE c1 = 2;
444
CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
445
SELECT COUNT(c1) AS value FROM t1;
448
SELECT COUNT(c1) AS postive_value FROM t1 WHERE c1 > 0;
451
SELECT COUNT(c1) AS negative_value FROM t1 WHERE c1 < 0;
454
SELECT COUNT(c1) AS zero_value FROM t1 WHERE c1 = 0;
457
SELECT COUNT(c1) AS no_results FROM t1 WHERE c1 = 2;
461
CREATE TABLE t1(c1 INT NOT NULL);
462
SELECT COUNT(c1) AS value FROM t1;
465
SELECT COUNT(c1) AS postive_value FROM t1 WHERE c1 > 0;
468
SELECT COUNT(c1) AS negative_value FROM t1 WHERE c1 < 0;
471
SELECT COUNT(c1) AS zero_value FROM t1 WHERE c1 = 0;
474
SELECT COUNT(c1) AS no_results FROM t1 WHERE c1 = 2;
478
CREATE TABLE t1(c1 INTEGER NOT NULL);
479
SELECT COUNT(c1) AS value FROM t1;
482
SELECT COUNT(c1) AS postive_value FROM t1 WHERE c1 > 0;
485
SELECT COUNT(c1) AS negative_value FROM t1 WHERE c1 < 0;
488
SELECT COUNT(c1) AS zero_value FROM t1 WHERE c1 = 0;
491
SELECT COUNT(c1) AS no_results FROM t1 WHERE c1 = 2;
495
CREATE TABLE t1(c1 BIGINT NOT NULL);
496
SELECT COUNT(c1) AS value FROM t1;
499
SELECT COUNT(c1) AS postive_value FROM t1 WHERE c1 > 0;
502
SELECT COUNT(c1) AS negative_value FROM t1 WHERE c1 < 0;
505
SELECT COUNT(c1) AS zero_value FROM t1 WHERE c1 = 0;
508
SELECT COUNT(c1) AS no_results FROM t1 WHERE c1 = 2;