1CREATE TABLE null_test ( 2 primary_key INTEGER PRIMARY KEY, 3 int_nulls INTEGER, 4 string_nulls STRING, 5 double_nulls DOUBLE, 6 start_int_nulls INTEGER, 7 start_string_nulls STRING, 8 start_double_nulls DOUBLE, 9 all_nulls INTEGER 10); 11 12INSERT INTO null_test( 13 int_nulls, 14 string_nulls, 15 double_nulls, 16 start_int_nulls, 17 start_string_nulls, 18 start_double_nulls 19) 20VALUES 21(1, "test", 2.0, NULL, NULL, NULL), 22(2, NULL, NULL, NULL, "test", NULL), 23(1, "other", NULL, NULL, NULL, NULL), 24(4, NULL, NULL, NULL, NULL, 1.0), 25(NULL, "test", 1.0, 1, NULL, NULL) 26 27SELECT * from null_test; 28