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