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;