drop table t1;
drop table t2;
drop table t3;
drop table t4;
drop table t5;
drop table t6;
drop table t7;
drop table t8;

Create table t1(a int);
Create table t2(a int);
Create table t3(a int);
Create table t4(a int);
Create table t5(a int);
Create table t6(a int);
Create table t7(a int);
Create table t8(a int);

insert into t1 values(generate_series(1,1000000));
insert into t2 values(generate_series(1,1000000));
insert into t3 values(generate_series(1,1000000));
insert into t4 values(generate_series(1,1000000));
insert into t5 values(generate_series(1,1000000));
insert into t6 values(generate_series(1,1000000));
insert into t7 values(generate_series(1,1000000));
insert into t8 values(generate_series(1,1000000));


delete from t1 where a % 2 = 0;
delete from t2 where a % 2 = 0;
delete from t3 where a % 2 = 0;
delete from t4 where a % 2 = 0;
delete from t5 where a % 2 = 0;
delete from t6 where a % 2 = 0;
delete from t7 where a % 2 = 0;
delete from t8 where a % 2 = 0;


insert into t1 values(generate_series(1,100000));
insert into t2 values(generate_series(1,100000));
insert into t3 values(generate_series(1,100000));
insert into t4 values(generate_series(1,100000));
insert into t5 values(generate_series(1,100000));
insert into t6 values(generate_series(1,100000));
insert into t7 values(generate_series(1,100000));
insert into t8 values(generate_series(1,100000));


delete from t1 where a % 3 = 0;
delete from t2 where a % 3 = 0;
delete from t3 where a % 3 = 0;
delete from t4 where a % 3 = 0;
delete from t5 where a % 3 = 0;
delete from t6 where a % 3 = 0;
delete from t7 where a % 3 = 0;
delete from t8 where a % 3 = 0;


insert into t1 values(generate_series(1,100000));
insert into t2 values(generate_series(1,100000));
insert into t3 values(generate_series(1,100000));
insert into t4 values(generate_series(1,100000));
insert into t5 values(generate_series(1,100000));
insert into t6 values(generate_series(1,100000));
insert into t7 values(generate_series(1,100000));
insert into t8 values(generate_series(1,100000));



delete from t1 where a % 4 = 0;
delete from t2 where a % 4 = 0;
delete from t3 where a % 4 = 0;
delete from t4 where a % 4 = 0;
delete from t5 where a % 4 = 0;
delete from t6 where a % 4 = 0;
delete from t7 where a % 4 = 0;
delete from t8 where a % 4 = 0;


delete from t1 where a % 5 = 0;
delete from t2 where a % 5 = 0;
delete from t3 where a % 5 = 0;
delete from t4 where a % 5 = 0;
delete from t5 where a % 5 = 0;
delete from t6 where a % 5 = 0;
delete from t7 where a % 5 = 0;
delete from t8 where a % 5 = 0;

delete from t1 where a % 8 = 0;
delete from t2 where a % 8 = 0;
delete from t3 where a % 8 = 0;
delete from t4 where a % 8 = 0;
delete from t5 where a % 8 = 0;
delete from t6 where a % 8 = 0;
delete from t7 where a % 8 = 0;
delete from t8 where a % 8 = 0;



























