1DROP TABLE IF EXISTS t3; 2CREATE TABLE t3(c1 TINYINT NULL); 3INSERT INTO t3 (c1) VALUES(0); 4INSERT INTO t3 (c1) VALUES(1); 5INSERT INTO t3 (c1) VALUES(16); 6INSERT INTO t3 (c1) VALUES(-4); 7INSERT INTO t3 (c1) VALUES(-9); 8INSERT INTO t3 (c1) VALUES(NULL); 9INSERT INTO t3 (c1) VALUES(NULL); 10INSERT INTO t3 (c1) VALUES(NULL); 11SELECT MAX(c1) AS value FROM t3; 12value 1316 14SELECT MAX(c1) AS postive_value FROM t3 WHERE c1 > 0; 15postive_value 1616 17SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 < 0; 18negative_value 19-4 20SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 = 2; 21negative_value 22NULL 23DROP TABLE t3; 24CREATE TABLE t3(c1 SMALLINT NULL); 25INSERT INTO t3 (c1) VALUES(0); 26INSERT INTO t3 (c1) VALUES(1); 27INSERT INTO t3 (c1) VALUES(16); 28INSERT INTO t3 (c1) VALUES(-4); 29INSERT INTO t3 (c1) VALUES(-9); 30INSERT INTO t3 (c1) VALUES(NULL); 31INSERT INTO t3 (c1) VALUES(NULL); 32INSERT INTO t3 (c1) VALUES(NULL); 33SELECT MAX(c1) AS value FROM t3; 34value 3516 36SELECT MAX(c1) AS postive_value FROM t3 WHERE c1 > 0; 37postive_value 3816 39SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 < 0; 40negative_value 41-4 42SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 = 2; 43negative_value 44NULL 45DROP TABLE t3; 46CREATE TABLE t3(c1 MEDIUMINT NULL); 47INSERT INTO t3 (c1) VALUES(0); 48INSERT INTO t3 (c1) VALUES(1); 49INSERT INTO t3 (c1) VALUES(16); 50INSERT INTO t3 (c1) VALUES(-4); 51INSERT INTO t3 (c1) VALUES(-9); 52INSERT INTO t3 (c1) VALUES(NULL); 53INSERT INTO t3 (c1) VALUES(NULL); 54INSERT INTO t3 (c1) VALUES(NULL); 55SELECT MAX(c1) AS value FROM t3; 56value 5716 58SELECT MAX(c1) AS postive_value FROM t3 WHERE c1 > 0; 59postive_value 6016 61SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 < 0; 62negative_value 63-4 64SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 = 2; 65negative_value 66NULL 67DROP TABLE t3; 68CREATE TABLE t3(c1 INT NULL); 69INSERT INTO t3 (c1) VALUES(0); 70INSERT INTO t3 (c1) VALUES(1); 71INSERT INTO t3 (c1) VALUES(16); 72INSERT INTO t3 (c1) VALUES(-4); 73INSERT INTO t3 (c1) VALUES(-9); 74INSERT INTO t3 (c1) VALUES(NULL); 75INSERT INTO t3 (c1) VALUES(NULL); 76INSERT INTO t3 (c1) VALUES(NULL); 77SELECT MAX(c1) AS value FROM t3; 78value 7916 80SELECT MAX(c1) AS postive_value FROM t3 WHERE c1 > 0; 81postive_value 8216 83SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 < 0; 84negative_value 85-4 86SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 = 2; 87negative_value 88NULL 89DROP TABLE t3; 90CREATE TABLE t3(c1 INTEGER NULL); 91INSERT INTO t3 (c1) VALUES(0); 92INSERT INTO t3 (c1) VALUES(1); 93INSERT INTO t3 (c1) VALUES(16); 94INSERT INTO t3 (c1) VALUES(-4); 95INSERT INTO t3 (c1) VALUES(-9); 96INSERT INTO t3 (c1) VALUES(NULL); 97INSERT INTO t3 (c1) VALUES(NULL); 98INSERT INTO t3 (c1) VALUES(NULL); 99SELECT MAX(c1) AS value FROM t3; 100value 10116 102SELECT MAX(c1) AS postive_value FROM t3 WHERE c1 > 0; 103postive_value 10416 105SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 < 0; 106negative_value 107-4 108SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 = 2; 109negative_value 110NULL 111DROP TABLE t3; 112CREATE TABLE t3(c1 BIGINT NULL); 113INSERT INTO t3 (c1) VALUES(0); 114INSERT INTO t3 (c1) VALUES(1); 115INSERT INTO t3 (c1) VALUES(16); 116INSERT INTO t3 (c1) VALUES(-4); 117INSERT INTO t3 (c1) VALUES(-9); 118INSERT INTO t3 (c1) VALUES(NULL); 119INSERT INTO t3 (c1) VALUES(NULL); 120INSERT INTO t3 (c1) VALUES(NULL); 121SELECT MAX(c1) AS value FROM t3; 122value 12316 124SELECT MAX(c1) AS postive_value FROM t3 WHERE c1 > 0; 125postive_value 12616 127SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 < 0; 128negative_value 129-4 130SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 = 2; 131negative_value 132NULL 133DROP TABLE t3; 134CREATE TABLE t3(c1 TINYINT NULL); 135INSERT INTO t3 (c1) VALUES(0); 136INSERT INTO t3 (c1) VALUES(1); 137INSERT INTO t3 (c1) VALUES(16); 138INSERT INTO t3 (c1) VALUES(-4); 139INSERT INTO t3 (c1) VALUES(-9); 140INSERT INTO t3 (c1) VALUES(NULL); 141INSERT INTO t3 (c1) VALUES(NULL); 142INSERT INTO t3 (c1) VALUES(NULL); 143SELECT MIN(c1) AS value FROM t3; 144value 145-9 146SELECT MIN(c1) AS postive_value FROM t3 WHERE c1 > 0; 147postive_value 1481 149SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 < 0; 150negative_value 151-9 152SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 = 2; 153negative_value 154NULL 155DROP TABLE t3; 156CREATE TABLE t3(c1 SMALLINT NULL); 157INSERT INTO t3 (c1) VALUES(0); 158INSERT INTO t3 (c1) VALUES(1); 159INSERT INTO t3 (c1) VALUES(16); 160INSERT INTO t3 (c1) VALUES(-4); 161INSERT INTO t3 (c1) VALUES(-9); 162INSERT INTO t3 (c1) VALUES(NULL); 163INSERT INTO t3 (c1) VALUES(NULL); 164INSERT INTO t3 (c1) VALUES(NULL); 165SELECT MIN(c1) AS value FROM t3; 166value 167-9 168SELECT MIN(c1) AS postive_value FROM t3 WHERE c1 > 0; 169postive_value 1701 171SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 < 0; 172negative_value 173-9 174SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 = 2; 175negative_value 176NULL 177DROP TABLE t3; 178CREATE TABLE t3(c1 MEDIUMINT NULL); 179INSERT INTO t3 (c1) VALUES(0); 180INSERT INTO t3 (c1) VALUES(1); 181INSERT INTO t3 (c1) VALUES(16); 182INSERT INTO t3 (c1) VALUES(-4); 183INSERT INTO t3 (c1) VALUES(-9); 184INSERT INTO t3 (c1) VALUES(NULL); 185INSERT INTO t3 (c1) VALUES(NULL); 186INSERT INTO t3 (c1) VALUES(NULL); 187SELECT MIN(c1) AS value FROM t3; 188value 189-9 190SELECT MIN(c1) AS postive_value FROM t3 WHERE c1 > 0; 191postive_value 1921 193SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 < 0; 194negative_value 195-9 196SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 = 2; 197negative_value 198NULL 199DROP TABLE t3; 200CREATE TABLE t3(c1 INT NULL); 201INSERT INTO t3 (c1) VALUES(0); 202INSERT INTO t3 (c1) VALUES(1); 203INSERT INTO t3 (c1) VALUES(16); 204INSERT INTO t3 (c1) VALUES(-4); 205INSERT INTO t3 (c1) VALUES(-9); 206INSERT INTO t3 (c1) VALUES(NULL); 207INSERT INTO t3 (c1) VALUES(NULL); 208INSERT INTO t3 (c1) VALUES(NULL); 209SELECT MIN(c1) AS value FROM t3; 210value 211-9 212SELECT MIN(c1) AS postive_value FROM t3 WHERE c1 > 0; 213postive_value 2141 215SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 < 0; 216negative_value 217-9 218SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 = 2; 219negative_value 220NULL 221DROP TABLE t3; 222CREATE TABLE t3(c1 INTEGER NULL); 223INSERT INTO t3 (c1) VALUES(0); 224INSERT INTO t3 (c1) VALUES(1); 225INSERT INTO t3 (c1) VALUES(16); 226INSERT INTO t3 (c1) VALUES(-4); 227INSERT INTO t3 (c1) VALUES(-9); 228INSERT INTO t3 (c1) VALUES(NULL); 229INSERT INTO t3 (c1) VALUES(NULL); 230INSERT INTO t3 (c1) VALUES(NULL); 231SELECT MIN(c1) AS value FROM t3; 232value 233-9 234SELECT MIN(c1) AS postive_value FROM t3 WHERE c1 > 0; 235postive_value 2361 237SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 < 0; 238negative_value 239-9 240SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 = 2; 241negative_value 242NULL 243DROP TABLE t3; 244CREATE TABLE t3(c1 BIGINT NULL); 245INSERT INTO t3 (c1) VALUES(0); 246INSERT INTO t3 (c1) VALUES(1); 247INSERT INTO t3 (c1) VALUES(16); 248INSERT INTO t3 (c1) VALUES(-4); 249INSERT INTO t3 (c1) VALUES(-9); 250INSERT INTO t3 (c1) VALUES(NULL); 251INSERT INTO t3 (c1) VALUES(NULL); 252INSERT INTO t3 (c1) VALUES(NULL); 253SELECT MIN(c1) AS value FROM t3; 254value 255-9 256SELECT MIN(c1) AS postive_value FROM t3 WHERE c1 > 0; 257postive_value 2581 259SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 < 0; 260negative_value 261-9 262SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 = 2; 263negative_value 264NULL 265DROP TABLE t3; 266CREATE TABLE t3(c1 TINYINT NULL); 267INSERT INTO t3 (c1) VALUES(0); 268INSERT INTO t3 (c1) VALUES(1); 269INSERT INTO t3 (c1) VALUES(16); 270INSERT INTO t3 (c1) VALUES(-4); 271INSERT INTO t3 (c1) VALUES(-9); 272INSERT INTO t3 (c1) VALUES(NULL); 273INSERT INTO t3 (c1) VALUES(NULL); 274INSERT INTO t3 (c1) VALUES(NULL); 275SELECT AVG(c1) AS value FROM t3; 276value 2770.8000 278SELECT AVG(c1) AS postive_value FROM t3 WHERE c1 > 0; 279postive_value 2808.5000 281SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 < 0; 282negative_value 283-6.5000 284SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 = 2; 285negative_value 286NULL 287DROP TABLE t3; 288CREATE TABLE t3(c1 SMALLINT NULL); 289INSERT INTO t3 (c1) VALUES(0); 290INSERT INTO t3 (c1) VALUES(1); 291INSERT INTO t3 (c1) VALUES(16); 292INSERT INTO t3 (c1) VALUES(-4); 293INSERT INTO t3 (c1) VALUES(-9); 294INSERT INTO t3 (c1) VALUES(NULL); 295INSERT INTO t3 (c1) VALUES(NULL); 296INSERT INTO t3 (c1) VALUES(NULL); 297SELECT AVG(c1) AS value FROM t3; 298value 2990.8000 300SELECT AVG(c1) AS postive_value FROM t3 WHERE c1 > 0; 301postive_value 3028.5000 303SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 < 0; 304negative_value 305-6.5000 306SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 = 2; 307negative_value 308NULL 309DROP TABLE t3; 310CREATE TABLE t3(c1 MEDIUMINT NULL); 311INSERT INTO t3 (c1) VALUES(0); 312INSERT INTO t3 (c1) VALUES(1); 313INSERT INTO t3 (c1) VALUES(16); 314INSERT INTO t3 (c1) VALUES(-4); 315INSERT INTO t3 (c1) VALUES(-9); 316INSERT INTO t3 (c1) VALUES(NULL); 317INSERT INTO t3 (c1) VALUES(NULL); 318INSERT INTO t3 (c1) VALUES(NULL); 319SELECT AVG(c1) AS value FROM t3; 320value 3210.8000 322SELECT AVG(c1) AS postive_value FROM t3 WHERE c1 > 0; 323postive_value 3248.5000 325SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 < 0; 326negative_value 327-6.5000 328SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 = 2; 329negative_value 330NULL 331DROP TABLE t3; 332CREATE TABLE t3(c1 INT NULL); 333INSERT INTO t3 (c1) VALUES(0); 334INSERT INTO t3 (c1) VALUES(1); 335INSERT INTO t3 (c1) VALUES(16); 336INSERT INTO t3 (c1) VALUES(-4); 337INSERT INTO t3 (c1) VALUES(-9); 338INSERT INTO t3 (c1) VALUES(NULL); 339INSERT INTO t3 (c1) VALUES(NULL); 340INSERT INTO t3 (c1) VALUES(NULL); 341SELECT AVG(c1) AS value FROM t3; 342value 3430.8000 344SELECT AVG(c1) AS postive_value FROM t3 WHERE c1 > 0; 345postive_value 3468.5000 347SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 < 0; 348negative_value 349-6.5000 350SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 = 2; 351negative_value 352NULL 353DROP TABLE t3; 354CREATE TABLE t3(c1 INTEGER NULL); 355INSERT INTO t3 (c1) VALUES(0); 356INSERT INTO t3 (c1) VALUES(1); 357INSERT INTO t3 (c1) VALUES(16); 358INSERT INTO t3 (c1) VALUES(-4); 359INSERT INTO t3 (c1) VALUES(-9); 360INSERT INTO t3 (c1) VALUES(NULL); 361INSERT INTO t3 (c1) VALUES(NULL); 362INSERT INTO t3 (c1) VALUES(NULL); 363SELECT AVG(c1) AS value FROM t3; 364value 3650.8000 366SELECT AVG(c1) AS postive_value FROM t3 WHERE c1 > 0; 367postive_value 3688.5000 369SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 < 0; 370negative_value 371-6.5000 372SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 = 2; 373negative_value 374NULL 375DROP TABLE t3; 376CREATE TABLE t3(c1 BIGINT NULL); 377INSERT INTO t3 (c1) VALUES(0); 378INSERT INTO t3 (c1) VALUES(1); 379INSERT INTO t3 (c1) VALUES(16); 380INSERT INTO t3 (c1) VALUES(-4); 381INSERT INTO t3 (c1) VALUES(-9); 382INSERT INTO t3 (c1) VALUES(NULL); 383INSERT INTO t3 (c1) VALUES(NULL); 384INSERT INTO t3 (c1) VALUES(NULL); 385SELECT AVG(c1) AS value FROM t3; 386value 3870.8000 388SELECT AVG(c1) AS postive_value FROM t3 WHERE c1 > 0; 389postive_value 3908.5000 391SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 < 0; 392negative_value 393-6.5000 394SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 = 2; 395negative_value 396NULL 397DROP TABLE t3; 398CREATE TABLE t3(c1 TINYINT NULL); 399INSERT INTO t3 (c1) VALUES(0); 400INSERT INTO t3 (c1) VALUES(1); 401INSERT INTO t3 (c1) VALUES(16); 402INSERT INTO t3 (c1) VALUES(-4); 403INSERT INTO t3 (c1) VALUES(-9); 404INSERT INTO t3 (c1) VALUES(NULL); 405INSERT INTO t3 (c1) VALUES(NULL); 406INSERT INTO t3 (c1) VALUES(NULL); 407SELECT SUM(c1) AS value FROM t3; 408value 4094 410SELECT SUM(c1) AS postive_value FROM t3 WHERE c1 > 0; 411postive_value 41217 413SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 < 0; 414negative_value 415-13 416SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 = 2; 417negative_value 418NULL 419DROP TABLE t3; 420CREATE TABLE t3(c1 SMALLINT NULL); 421INSERT INTO t3 (c1) VALUES(0); 422INSERT INTO t3 (c1) VALUES(1); 423INSERT INTO t3 (c1) VALUES(16); 424INSERT INTO t3 (c1) VALUES(-4); 425INSERT INTO t3 (c1) VALUES(-9); 426INSERT INTO t3 (c1) VALUES(NULL); 427INSERT INTO t3 (c1) VALUES(NULL); 428INSERT INTO t3 (c1) VALUES(NULL); 429SELECT SUM(c1) AS value FROM t3; 430value 4314 432SELECT SUM(c1) AS postive_value FROM t3 WHERE c1 > 0; 433postive_value 43417 435SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 < 0; 436negative_value 437-13 438SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 = 2; 439negative_value 440NULL 441DROP TABLE t3; 442CREATE TABLE t3(c1 MEDIUMINT NULL); 443INSERT INTO t3 (c1) VALUES(0); 444INSERT INTO t3 (c1) VALUES(1); 445INSERT INTO t3 (c1) VALUES(16); 446INSERT INTO t3 (c1) VALUES(-4); 447INSERT INTO t3 (c1) VALUES(-9); 448INSERT INTO t3 (c1) VALUES(NULL); 449INSERT INTO t3 (c1) VALUES(NULL); 450INSERT INTO t3 (c1) VALUES(NULL); 451SELECT SUM(c1) AS value FROM t3; 452value 4534 454SELECT SUM(c1) AS postive_value FROM t3 WHERE c1 > 0; 455postive_value 45617 457SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 < 0; 458negative_value 459-13 460SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 = 2; 461negative_value 462NULL 463DROP TABLE t3; 464CREATE TABLE t3(c1 INT NULL); 465INSERT INTO t3 (c1) VALUES(0); 466INSERT INTO t3 (c1) VALUES(1); 467INSERT INTO t3 (c1) VALUES(16); 468INSERT INTO t3 (c1) VALUES(-4); 469INSERT INTO t3 (c1) VALUES(-9); 470INSERT INTO t3 (c1) VALUES(NULL); 471INSERT INTO t3 (c1) VALUES(NULL); 472INSERT INTO t3 (c1) VALUES(NULL); 473SELECT SUM(c1) AS value FROM t3; 474value 4754 476SELECT SUM(c1) AS postive_value FROM t3 WHERE c1 > 0; 477postive_value 47817 479SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 < 0; 480negative_value 481-13 482SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 = 2; 483negative_value 484NULL 485DROP TABLE t3; 486CREATE TABLE t3(c1 INTEGER NULL); 487INSERT INTO t3 (c1) VALUES(0); 488INSERT INTO t3 (c1) VALUES(1); 489INSERT INTO t3 (c1) VALUES(16); 490INSERT INTO t3 (c1) VALUES(-4); 491INSERT INTO t3 (c1) VALUES(-9); 492INSERT INTO t3 (c1) VALUES(NULL); 493INSERT INTO t3 (c1) VALUES(NULL); 494INSERT INTO t3 (c1) VALUES(NULL); 495SELECT SUM(c1) AS value FROM t3; 496value 4974 498SELECT SUM(c1) AS postive_value FROM t3 WHERE c1 > 0; 499postive_value 50017 501SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 < 0; 502negative_value 503-13 504SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 = 2; 505negative_value 506NULL 507DROP TABLE t3; 508CREATE TABLE t3(c1 BIGINT NULL); 509INSERT INTO t3 (c1) VALUES(0); 510INSERT INTO t3 (c1) VALUES(1); 511INSERT INTO t3 (c1) VALUES(16); 512INSERT INTO t3 (c1) VALUES(-4); 513INSERT INTO t3 (c1) VALUES(-9); 514INSERT INTO t3 (c1) VALUES(NULL); 515INSERT INTO t3 (c1) VALUES(NULL); 516INSERT INTO t3 (c1) VALUES(NULL); 517SELECT SUM(c1) AS value FROM t3; 518value 5194 520SELECT SUM(c1) AS postive_value FROM t3 WHERE c1 > 0; 521postive_value 52217 523SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 < 0; 524negative_value 525-13 526SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 = 2; 527negative_value 528NULL 529DROP TABLE t3; 530CREATE TABLE t3(c1 TINYINT NULL); 531INSERT INTO t3 (c1) VALUES(0); 532INSERT INTO t3 (c1) VALUES(1); 533INSERT INTO t3 (c1) VALUES(16); 534INSERT INTO t3 (c1) VALUES(-4); 535INSERT INTO t3 (c1) VALUES(-9); 536INSERT INTO t3 (c1) VALUES(NULL); 537INSERT INTO t3 (c1) VALUES(NULL); 538INSERT INTO t3 (c1) VALUES(NULL); 539SELECT COUNT(c1) AS value FROM t3; 540value 5415 542SELECT COUNT(c1) AS postive_value FROM t3 WHERE c1 > 0; 543postive_value 5442 545SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 < 0; 546negative_value 5472 548SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 = 2; 549negative_value 5500 551DROP TABLE t3; 552CREATE TABLE t3(c1 SMALLINT NULL); 553INSERT INTO t3 (c1) VALUES(0); 554INSERT INTO t3 (c1) VALUES(1); 555INSERT INTO t3 (c1) VALUES(16); 556INSERT INTO t3 (c1) VALUES(-4); 557INSERT INTO t3 (c1) VALUES(-9); 558INSERT INTO t3 (c1) VALUES(NULL); 559INSERT INTO t3 (c1) VALUES(NULL); 560INSERT INTO t3 (c1) VALUES(NULL); 561SELECT COUNT(c1) AS value FROM t3; 562value 5635 564SELECT COUNT(c1) AS postive_value FROM t3 WHERE c1 > 0; 565postive_value 5662 567SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 < 0; 568negative_value 5692 570SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 = 2; 571negative_value 5720 573DROP TABLE t3; 574CREATE TABLE t3(c1 MEDIUMINT NULL); 575INSERT INTO t3 (c1) VALUES(0); 576INSERT INTO t3 (c1) VALUES(1); 577INSERT INTO t3 (c1) VALUES(16); 578INSERT INTO t3 (c1) VALUES(-4); 579INSERT INTO t3 (c1) VALUES(-9); 580INSERT INTO t3 (c1) VALUES(NULL); 581INSERT INTO t3 (c1) VALUES(NULL); 582INSERT INTO t3 (c1) VALUES(NULL); 583SELECT COUNT(c1) AS value FROM t3; 584value 5855 586SELECT COUNT(c1) AS postive_value FROM t3 WHERE c1 > 0; 587postive_value 5882 589SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 < 0; 590negative_value 5912 592SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 = 2; 593negative_value 5940 595DROP TABLE t3; 596CREATE TABLE t3(c1 INT NULL); 597INSERT INTO t3 (c1) VALUES(0); 598INSERT INTO t3 (c1) VALUES(1); 599INSERT INTO t3 (c1) VALUES(16); 600INSERT INTO t3 (c1) VALUES(-4); 601INSERT INTO t3 (c1) VALUES(-9); 602INSERT INTO t3 (c1) VALUES(NULL); 603INSERT INTO t3 (c1) VALUES(NULL); 604INSERT INTO t3 (c1) VALUES(NULL); 605SELECT COUNT(c1) AS value FROM t3; 606value 6075 608SELECT COUNT(c1) AS postive_value FROM t3 WHERE c1 > 0; 609postive_value 6102 611SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 < 0; 612negative_value 6132 614SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 = 2; 615negative_value 6160 617DROP TABLE t3; 618CREATE TABLE t3(c1 INTEGER NULL); 619INSERT INTO t3 (c1) VALUES(0); 620INSERT INTO t3 (c1) VALUES(1); 621INSERT INTO t3 (c1) VALUES(16); 622INSERT INTO t3 (c1) VALUES(-4); 623INSERT INTO t3 (c1) VALUES(-9); 624INSERT INTO t3 (c1) VALUES(NULL); 625INSERT INTO t3 (c1) VALUES(NULL); 626INSERT INTO t3 (c1) VALUES(NULL); 627SELECT COUNT(c1) AS value FROM t3; 628value 6295 630SELECT COUNT(c1) AS postive_value FROM t3 WHERE c1 > 0; 631postive_value 6322 633SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 < 0; 634negative_value 6352 636SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 = 2; 637negative_value 6380 639DROP TABLE t3; 640CREATE TABLE t3(c1 BIGINT NULL); 641INSERT INTO t3 (c1) VALUES(0); 642INSERT INTO t3 (c1) VALUES(1); 643INSERT INTO t3 (c1) VALUES(16); 644INSERT INTO t3 (c1) VALUES(-4); 645INSERT INTO t3 (c1) VALUES(-9); 646INSERT INTO t3 (c1) VALUES(NULL); 647INSERT INTO t3 (c1) VALUES(NULL); 648INSERT INTO t3 (c1) VALUES(NULL); 649SELECT COUNT(c1) AS value FROM t3; 650value 6515 652SELECT COUNT(c1) AS postive_value FROM t3 WHERE c1 > 0; 653postive_value 6542 655SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 < 0; 656negative_value 6572 658SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 = 2; 659negative_value 6600 661DROP TABLE t3; 662