1
DROP TABLE IF EXISTS t2;
2
CREATE TABLE t2(c1 TINYINT NOT NULL);
3
INSERT INTO t2 (c1) VALUES(0);
4
INSERT INTO t2 (c1) VALUES(1);
5
INSERT INTO t2 (c1) VALUES(16);
6
INSERT INTO t2 (c1) VALUES(-4);
7
INSERT INTO t2 (c1) VALUES(-9);
8
SELECT MAX(c1) AS value FROM t2;
11
SELECT MAX(c1) AS postive_value FROM t2 WHERE c1 > 0;
14
SELECT MAX(c1) AS negative_value FROM t2 WHERE c1 < 0;
17
SELECT MAX(c1) AS zero_value FROM t2 WHERE c1 = 0;
20
SELECT MAX(c1) AS no_results FROM t2 WHERE c1 = 2;
24
CREATE TABLE t2(c1 SMALLINT NOT NULL);
25
INSERT INTO t2 (c1) VALUES(0);
26
INSERT INTO t2 (c1) VALUES(1);
27
INSERT INTO t2 (c1) VALUES(16);
28
INSERT INTO t2 (c1) VALUES(-4);
29
INSERT INTO t2 (c1) VALUES(-9);
30
SELECT MAX(c1) AS value FROM t2;
33
SELECT MAX(c1) AS postive_value FROM t2 WHERE c1 > 0;
36
SELECT MAX(c1) AS negative_value FROM t2 WHERE c1 < 0;
39
SELECT MAX(c1) AS zero_value FROM t2 WHERE c1 = 0;
42
SELECT MAX(c1) AS no_results FROM t2 WHERE c1 = 2;
46
CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
47
INSERT INTO t2 (c1) VALUES(0);
48
INSERT INTO t2 (c1) VALUES(1);
49
INSERT INTO t2 (c1) VALUES(16);
50
INSERT INTO t2 (c1) VALUES(-4);
51
INSERT INTO t2 (c1) VALUES(-9);
52
SELECT MAX(c1) AS value FROM t2;
55
SELECT MAX(c1) AS postive_value FROM t2 WHERE c1 > 0;
58
SELECT MAX(c1) AS negative_value FROM t2 WHERE c1 < 0;
61
SELECT MAX(c1) AS zero_value FROM t2 WHERE c1 = 0;
64
SELECT MAX(c1) AS no_results FROM t2 WHERE c1 = 2;
68
CREATE TABLE t2(c1 INT NOT NULL);
69
INSERT INTO t2 (c1) VALUES(0);
70
INSERT INTO t2 (c1) VALUES(1);
71
INSERT INTO t2 (c1) VALUES(16);
72
INSERT INTO t2 (c1) VALUES(-4);
73
INSERT INTO t2 (c1) VALUES(-9);
74
SELECT MAX(c1) AS value FROM t2;
77
SELECT MAX(c1) AS postive_value FROM t2 WHERE c1 > 0;
80
SELECT MAX(c1) AS negative_value FROM t2 WHERE c1 < 0;
83
SELECT MAX(c1) AS zero_value FROM t2 WHERE c1 = 0;
86
SELECT MAX(c1) AS no_results FROM t2 WHERE c1 = 2;
90
CREATE TABLE t2(c1 INTEGER NOT NULL);
91
INSERT INTO t2 (c1) VALUES(0);
92
INSERT INTO t2 (c1) VALUES(1);
93
INSERT INTO t2 (c1) VALUES(16);
94
INSERT INTO t2 (c1) VALUES(-4);
95
INSERT INTO t2 (c1) VALUES(-9);
96
SELECT MAX(c1) AS value FROM t2;
99
SELECT MAX(c1) AS postive_value FROM t2 WHERE c1 > 0;
102
SELECT MAX(c1) AS negative_value FROM t2 WHERE c1 < 0;
105
SELECT MAX(c1) AS zero_value FROM t2 WHERE c1 = 0;
108
SELECT MAX(c1) AS no_results FROM t2 WHERE c1 = 2;
112
CREATE TABLE t2(c1 BIGINT NOT NULL);
113
INSERT INTO t2 (c1) VALUES(0);
114
INSERT INTO t2 (c1) VALUES(1);
115
INSERT INTO t2 (c1) VALUES(16);
116
INSERT INTO t2 (c1) VALUES(-4);
117
INSERT INTO t2 (c1) VALUES(-9);
118
SELECT MAX(c1) AS value FROM t2;
121
SELECT MAX(c1) AS postive_value FROM t2 WHERE c1 > 0;
124
SELECT MAX(c1) AS negative_value FROM t2 WHERE c1 < 0;
127
SELECT MAX(c1) AS zero_value FROM t2 WHERE c1 = 0;
130
SELECT MAX(c1) AS no_results FROM t2 WHERE c1 = 2;
134
CREATE TABLE t2(c1 TINYINT NOT NULL);
135
INSERT INTO t2 (c1) VALUES(0);
136
INSERT INTO t2 (c1) VALUES(1);
137
INSERT INTO t2 (c1) VALUES(16);
138
INSERT INTO t2 (c1) VALUES(-4);
139
INSERT INTO t2 (c1) VALUES(-9);
140
SELECT MIN(c1) AS value FROM t2;
143
SELECT MIN(c1) AS postive_value FROM t2 WHERE c1 > 0;
146
SELECT MIN(c1) AS negative_value FROM t2 WHERE c1 < 0;
149
SELECT MIN(c1) AS zero_value FROM t2 WHERE c1 = 0;
152
SELECT MIN(c1) AS no_results FROM t2 WHERE c1 = 2;
156
CREATE TABLE t2(c1 SMALLINT NOT NULL);
157
INSERT INTO t2 (c1) VALUES(0);
158
INSERT INTO t2 (c1) VALUES(1);
159
INSERT INTO t2 (c1) VALUES(16);
160
INSERT INTO t2 (c1) VALUES(-4);
161
INSERT INTO t2 (c1) VALUES(-9);
162
SELECT MIN(c1) AS value FROM t2;
165
SELECT MIN(c1) AS postive_value FROM t2 WHERE c1 > 0;
168
SELECT MIN(c1) AS negative_value FROM t2 WHERE c1 < 0;
171
SELECT MIN(c1) AS zero_value FROM t2 WHERE c1 = 0;
174
SELECT MIN(c1) AS no_results FROM t2 WHERE c1 = 2;
178
CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
179
INSERT INTO t2 (c1) VALUES(0);
180
INSERT INTO t2 (c1) VALUES(1);
181
INSERT INTO t2 (c1) VALUES(16);
182
INSERT INTO t2 (c1) VALUES(-4);
183
INSERT INTO t2 (c1) VALUES(-9);
184
SELECT MIN(c1) AS value FROM t2;
187
SELECT MIN(c1) AS postive_value FROM t2 WHERE c1 > 0;
190
SELECT MIN(c1) AS negative_value FROM t2 WHERE c1 < 0;
193
SELECT MIN(c1) AS zero_value FROM t2 WHERE c1 = 0;
196
SELECT MIN(c1) AS no_results FROM t2 WHERE c1 = 2;
200
CREATE TABLE t2(c1 INT NOT NULL);
201
INSERT INTO t2 (c1) VALUES(0);
202
INSERT INTO t2 (c1) VALUES(1);
203
INSERT INTO t2 (c1) VALUES(16);
204
INSERT INTO t2 (c1) VALUES(-4);
205
INSERT INTO t2 (c1) VALUES(-9);
206
SELECT MIN(c1) AS value FROM t2;
209
SELECT MIN(c1) AS postive_value FROM t2 WHERE c1 > 0;
212
SELECT MIN(c1) AS negative_value FROM t2 WHERE c1 < 0;
215
SELECT MIN(c1) AS zero_value FROM t2 WHERE c1 = 0;
218
SELECT MIN(c1) AS no_results FROM t2 WHERE c1 = 2;
222
CREATE TABLE t2(c1 INTEGER NOT NULL);
223
INSERT INTO t2 (c1) VALUES(0);
224
INSERT INTO t2 (c1) VALUES(1);
225
INSERT INTO t2 (c1) VALUES(16);
226
INSERT INTO t2 (c1) VALUES(-4);
227
INSERT INTO t2 (c1) VALUES(-9);
228
SELECT MIN(c1) AS value FROM t2;
231
SELECT MIN(c1) AS postive_value FROM t2 WHERE c1 > 0;
234
SELECT MIN(c1) AS negative_value FROM t2 WHERE c1 < 0;
237
SELECT MIN(c1) AS zero_value FROM t2 WHERE c1 = 0;
240
SELECT MIN(c1) AS no_results FROM t2 WHERE c1 = 2;
244
CREATE TABLE t2(c1 BIGINT NOT NULL);
245
INSERT INTO t2 (c1) VALUES(0);
246
INSERT INTO t2 (c1) VALUES(1);
247
INSERT INTO t2 (c1) VALUES(16);
248
INSERT INTO t2 (c1) VALUES(-4);
249
INSERT INTO t2 (c1) VALUES(-9);
250
SELECT MIN(c1) AS value FROM t2;
253
SELECT MIN(c1) AS postive_value FROM t2 WHERE c1 > 0;
256
SELECT MIN(c1) AS negative_value FROM t2 WHERE c1 < 0;
259
SELECT MIN(c1) AS zero_value FROM t2 WHERE c1 = 0;
262
SELECT MIN(c1) AS no_results FROM t2 WHERE c1 = 2;
266
CREATE TABLE t2(c1 TINYINT NOT NULL);
267
INSERT INTO t2 (c1) VALUES(0);
268
INSERT INTO t2 (c1) VALUES(1);
269
INSERT INTO t2 (c1) VALUES(16);
270
INSERT INTO t2 (c1) VALUES(-4);
271
INSERT INTO t2 (c1) VALUES(-9);
272
SELECT AVG(c1) AS value FROM t2;
275
SELECT AVG(c1) AS postive_value FROM t2 WHERE c1 > 0;
278
SELECT AVG(c1) AS negative_value FROM t2 WHERE c1 < 0;
281
SELECT AVG(c1) AS zero_value FROM t2 WHERE c1 = 0;
284
SELECT AVG(c1) AS no_results FROM t2 WHERE c1 = 2;
288
CREATE TABLE t2(c1 SMALLINT NOT NULL);
289
INSERT INTO t2 (c1) VALUES(0);
290
INSERT INTO t2 (c1) VALUES(1);
291
INSERT INTO t2 (c1) VALUES(16);
292
INSERT INTO t2 (c1) VALUES(-4);
293
INSERT INTO t2 (c1) VALUES(-9);
294
SELECT AVG(c1) AS value FROM t2;
297
SELECT AVG(c1) AS postive_value FROM t2 WHERE c1 > 0;
300
SELECT AVG(c1) AS negative_value FROM t2 WHERE c1 < 0;
303
SELECT AVG(c1) AS zero_value FROM t2 WHERE c1 = 0;
306
SELECT AVG(c1) AS no_results FROM t2 WHERE c1 = 2;
310
CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
311
INSERT INTO t2 (c1) VALUES(0);
312
INSERT INTO t2 (c1) VALUES(1);
313
INSERT INTO t2 (c1) VALUES(16);
314
INSERT INTO t2 (c1) VALUES(-4);
315
INSERT INTO t2 (c1) VALUES(-9);
316
SELECT AVG(c1) AS value FROM t2;
319
SELECT AVG(c1) AS postive_value FROM t2 WHERE c1 > 0;
322
SELECT AVG(c1) AS negative_value FROM t2 WHERE c1 < 0;
325
SELECT AVG(c1) AS zero_value FROM t2 WHERE c1 = 0;
328
SELECT AVG(c1) AS no_results FROM t2 WHERE c1 = 2;
332
CREATE TABLE t2(c1 INT NOT NULL);
333
INSERT INTO t2 (c1) VALUES(0);
334
INSERT INTO t2 (c1) VALUES(1);
335
INSERT INTO t2 (c1) VALUES(16);
336
INSERT INTO t2 (c1) VALUES(-4);
337
INSERT INTO t2 (c1) VALUES(-9);
338
SELECT AVG(c1) AS value FROM t2;
341
SELECT AVG(c1) AS postive_value FROM t2 WHERE c1 > 0;
344
SELECT AVG(c1) AS negative_value FROM t2 WHERE c1 < 0;
347
SELECT AVG(c1) AS zero_value FROM t2 WHERE c1 = 0;
350
SELECT AVG(c1) AS no_results FROM t2 WHERE c1 = 2;
354
CREATE TABLE t2(c1 INTEGER NOT NULL);
355
INSERT INTO t2 (c1) VALUES(0);
356
INSERT INTO t2 (c1) VALUES(1);
357
INSERT INTO t2 (c1) VALUES(16);
358
INSERT INTO t2 (c1) VALUES(-4);
359
INSERT INTO t2 (c1) VALUES(-9);
360
SELECT AVG(c1) AS value FROM t2;
363
SELECT AVG(c1) AS postive_value FROM t2 WHERE c1 > 0;
366
SELECT AVG(c1) AS negative_value FROM t2 WHERE c1 < 0;
369
SELECT AVG(c1) AS zero_value FROM t2 WHERE c1 = 0;
372
SELECT AVG(c1) AS no_results FROM t2 WHERE c1 = 2;
376
CREATE TABLE t2(c1 BIGINT NOT NULL);
377
INSERT INTO t2 (c1) VALUES(0);
378
INSERT INTO t2 (c1) VALUES(1);
379
INSERT INTO t2 (c1) VALUES(16);
380
INSERT INTO t2 (c1) VALUES(-4);
381
INSERT INTO t2 (c1) VALUES(-9);
382
SELECT AVG(c1) AS value FROM t2;
385
SELECT AVG(c1) AS postive_value FROM t2 WHERE c1 > 0;
388
SELECT AVG(c1) AS negative_value FROM t2 WHERE c1 < 0;
391
SELECT AVG(c1) AS zero_value FROM t2 WHERE c1 = 0;
394
SELECT AVG(c1) AS no_results FROM t2 WHERE c1 = 2;
398
CREATE TABLE t2(c1 TINYINT NOT NULL);
399
INSERT INTO t2 (c1) VALUES(0);
400
INSERT INTO t2 (c1) VALUES(1);
401
INSERT INTO t2 (c1) VALUES(16);
402
INSERT INTO t2 (c1) VALUES(-4);
403
INSERT INTO t2 (c1) VALUES(-9);
404
SELECT SUM(c1) AS value FROM t2;
407
SELECT SUM(c1) AS postive_value FROM t2 WHERE c1 > 0;
410
SELECT SUM(c1) AS negative_value FROM t2 WHERE c1 < 0;
413
SELECT SUM(c1) AS zero_value FROM t2 WHERE c1 = 0;
416
SELECT SUM(c1) AS no_results FROM t2 WHERE c1 = 2;
420
CREATE TABLE t2(c1 SMALLINT NOT NULL);
421
INSERT INTO t2 (c1) VALUES(0);
422
INSERT INTO t2 (c1) VALUES(1);
423
INSERT INTO t2 (c1) VALUES(16);
424
INSERT INTO t2 (c1) VALUES(-4);
425
INSERT INTO t2 (c1) VALUES(-9);
426
SELECT SUM(c1) AS value FROM t2;
429
SELECT SUM(c1) AS postive_value FROM t2 WHERE c1 > 0;
432
SELECT SUM(c1) AS negative_value FROM t2 WHERE c1 < 0;
435
SELECT SUM(c1) AS zero_value FROM t2 WHERE c1 = 0;
438
SELECT SUM(c1) AS no_results FROM t2 WHERE c1 = 2;
442
CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
443
INSERT INTO t2 (c1) VALUES(0);
444
INSERT INTO t2 (c1) VALUES(1);
445
INSERT INTO t2 (c1) VALUES(16);
446
INSERT INTO t2 (c1) VALUES(-4);
447
INSERT INTO t2 (c1) VALUES(-9);
448
SELECT SUM(c1) AS value FROM t2;
451
SELECT SUM(c1) AS postive_value FROM t2 WHERE c1 > 0;
454
SELECT SUM(c1) AS negative_value FROM t2 WHERE c1 < 0;
457
SELECT SUM(c1) AS zero_value FROM t2 WHERE c1 = 0;
460
SELECT SUM(c1) AS no_results FROM t2 WHERE c1 = 2;
464
CREATE TABLE t2(c1 INT NOT NULL);
465
INSERT INTO t2 (c1) VALUES(0);
466
INSERT INTO t2 (c1) VALUES(1);
467
INSERT INTO t2 (c1) VALUES(16);
468
INSERT INTO t2 (c1) VALUES(-4);
469
INSERT INTO t2 (c1) VALUES(-9);
470
SELECT SUM(c1) AS value FROM t2;
473
SELECT SUM(c1) AS postive_value FROM t2 WHERE c1 > 0;
476
SELECT SUM(c1) AS negative_value FROM t2 WHERE c1 < 0;
479
SELECT SUM(c1) AS zero_value FROM t2 WHERE c1 = 0;
482
SELECT SUM(c1) AS no_results FROM t2 WHERE c1 = 2;
486
CREATE TABLE t2(c1 INTEGER NOT NULL);
487
INSERT INTO t2 (c1) VALUES(0);
488
INSERT INTO t2 (c1) VALUES(1);
489
INSERT INTO t2 (c1) VALUES(16);
490
INSERT INTO t2 (c1) VALUES(-4);
491
INSERT INTO t2 (c1) VALUES(-9);
492
SELECT SUM(c1) AS value FROM t2;
495
SELECT SUM(c1) AS postive_value FROM t2 WHERE c1 > 0;
498
SELECT SUM(c1) AS negative_value FROM t2 WHERE c1 < 0;
501
SELECT SUM(c1) AS zero_value FROM t2 WHERE c1 = 0;
504
SELECT SUM(c1) AS no_results FROM t2 WHERE c1 = 2;
508
CREATE TABLE t2(c1 BIGINT NOT NULL);
509
INSERT INTO t2 (c1) VALUES(0);
510
INSERT INTO t2 (c1) VALUES(1);
511
INSERT INTO t2 (c1) VALUES(16);
512
INSERT INTO t2 (c1) VALUES(-4);
513
INSERT INTO t2 (c1) VALUES(-9);
514
SELECT SUM(c1) AS value FROM t2;
517
SELECT SUM(c1) AS postive_value FROM t2 WHERE c1 > 0;
520
SELECT SUM(c1) AS negative_value FROM t2 WHERE c1 < 0;
523
SELECT SUM(c1) AS zero_value FROM t2 WHERE c1 = 0;
526
SELECT SUM(c1) AS no_results FROM t2 WHERE c1 = 2;
530
CREATE TABLE t2(c1 TINYINT NOT NULL);
531
INSERT INTO t2 (c1) VALUES(0);
532
INSERT INTO t2 (c1) VALUES(1);
533
INSERT INTO t2 (c1) VALUES(16);
534
INSERT INTO t2 (c1) VALUES(-4);
535
INSERT INTO t2 (c1) VALUES(-9);
536
SELECT COUNT(c1) AS value FROM t2;
539
SELECT COUNT(c1) AS postive_value FROM t2 WHERE c1 > 0;
542
SELECT COUNT(c1) AS negative_value FROM t2 WHERE c1 < 0;
545
SELECT COUNT(c1) AS zero_value FROM t2 WHERE c1 = 0;
548
SELECT COUNT(c1) AS no_results FROM t2 WHERE c1 = 2;
552
CREATE TABLE t2(c1 SMALLINT NOT NULL);
553
INSERT INTO t2 (c1) VALUES(0);
554
INSERT INTO t2 (c1) VALUES(1);
555
INSERT INTO t2 (c1) VALUES(16);
556
INSERT INTO t2 (c1) VALUES(-4);
557
INSERT INTO t2 (c1) VALUES(-9);
558
SELECT COUNT(c1) AS value FROM t2;
561
SELECT COUNT(c1) AS postive_value FROM t2 WHERE c1 > 0;
564
SELECT COUNT(c1) AS negative_value FROM t2 WHERE c1 < 0;
567
SELECT COUNT(c1) AS zero_value FROM t2 WHERE c1 = 0;
570
SELECT COUNT(c1) AS no_results FROM t2 WHERE c1 = 2;
574
CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
575
INSERT INTO t2 (c1) VALUES(0);
576
INSERT INTO t2 (c1) VALUES(1);
577
INSERT INTO t2 (c1) VALUES(16);
578
INSERT INTO t2 (c1) VALUES(-4);
579
INSERT INTO t2 (c1) VALUES(-9);
580
SELECT COUNT(c1) AS value FROM t2;
583
SELECT COUNT(c1) AS postive_value FROM t2 WHERE c1 > 0;
586
SELECT COUNT(c1) AS negative_value FROM t2 WHERE c1 < 0;
589
SELECT COUNT(c1) AS zero_value FROM t2 WHERE c1 = 0;
592
SELECT COUNT(c1) AS no_results FROM t2 WHERE c1 = 2;
596
CREATE TABLE t2(c1 INT NOT NULL);
597
INSERT INTO t2 (c1) VALUES(0);
598
INSERT INTO t2 (c1) VALUES(1);
599
INSERT INTO t2 (c1) VALUES(16);
600
INSERT INTO t2 (c1) VALUES(-4);
601
INSERT INTO t2 (c1) VALUES(-9);
602
SELECT COUNT(c1) AS value FROM t2;
605
SELECT COUNT(c1) AS postive_value FROM t2 WHERE c1 > 0;
608
SELECT COUNT(c1) AS negative_value FROM t2 WHERE c1 < 0;
611
SELECT COUNT(c1) AS zero_value FROM t2 WHERE c1 = 0;
614
SELECT COUNT(c1) AS no_results FROM t2 WHERE c1 = 2;
618
CREATE TABLE t2(c1 INTEGER NOT NULL);
619
INSERT INTO t2 (c1) VALUES(0);
620
INSERT INTO t2 (c1) VALUES(1);
621
INSERT INTO t2 (c1) VALUES(16);
622
INSERT INTO t2 (c1) VALUES(-4);
623
INSERT INTO t2 (c1) VALUES(-9);
624
SELECT COUNT(c1) AS value FROM t2;
627
SELECT COUNT(c1) AS postive_value FROM t2 WHERE c1 > 0;
630
SELECT COUNT(c1) AS negative_value FROM t2 WHERE c1 < 0;
633
SELECT COUNT(c1) AS zero_value FROM t2 WHERE c1 = 0;
636
SELECT COUNT(c1) AS no_results FROM t2 WHERE c1 = 2;
640
CREATE TABLE t2(c1 BIGINT NOT NULL);
641
INSERT INTO t2 (c1) VALUES(0);
642
INSERT INTO t2 (c1) VALUES(1);
643
INSERT INTO t2 (c1) VALUES(16);
644
INSERT INTO t2 (c1) VALUES(-4);
645
INSERT INTO t2 (c1) VALUES(-9);
646
SELECT COUNT(c1) AS value FROM t2;
649
SELECT COUNT(c1) AS postive_value FROM t2 WHERE c1 > 0;
652
SELECT COUNT(c1) AS negative_value FROM t2 WHERE c1 < 0;
655
SELECT COUNT(c1) AS zero_value FROM t2 WHERE c1 = 0;
658
SELECT COUNT(c1) AS no_results FROM t2 WHERE c1 = 2;