USE ssb1;
select count(*)
from     dateinfo d1,
supplier s2,
customer c4,
customer c1,
customer c3_um,
lineorder 
where lo_orderkey > 0      and lo_orderdate = d1.d_datekey
and lo_suppkey = s2.s_suppkey
and lo_custkey = c4.c_custkey
and lo_custkey = c1.c_custkey
and lo_custkey = c3_um.c_custkey
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and s2.s_city in ('ALGERIA  0','ALGERIA  1','ALGERIA  2','GERMANY  0','GERMANY  1','UNITED KI2','UNITED KI3')
and c4.c_region in ('EUROPE')
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
;
count(*)
991
select count(*)
from     dateinfo d2,
supplier s1,
customer c3_um,
customer c2_um,
customer c4,
lineorder 
where lo_orderkey > 0      and lo_orderdate = d2.d_datekey
and lo_suppkey = s1.s_suppkey
and lo_custkey = c3_um.c_custkey
and lo_custkey = c2_um.c_custkey
and lo_custkey = c4.c_custkey
and d2.d_year = 1994
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and c4.c_region in ('EUROPE')
;
count(*)
66692
select count(*)
from     customer c1,
part p4_um,
customer c2_um,
customer c3_um,
part p1,
lineorder 
where lo_orderkey > 0      and lo_custkey = c1.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_custkey = c2_um.c_custkey
and lo_custkey = c3_um.c_custkey
and lo_partkey = p1.p_partkey
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p4_um.p_category <= 'MFGR#13'
    and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
;
count(*)
129142
select count(*)
from     customer c2_um,
part p3,
customer c1,
customer c4,
part p2_um,
lineorder 
where lo_orderkey > 0      and lo_custkey = c2_um.c_custkey
and lo_partkey = p3.p_partkey
and lo_custkey = c1.c_custkey
and lo_custkey = c4.c_custkey
and lo_partkey = p2_um.p_partkey
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and p3.p_category <= 'MFGR#13'
    and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and c4.c_region in ('EUROPE')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
;
count(*)
66952
select count(*)
from     customer c3_um,
part p2_um,
dateinfo d2,
part p1,
part p3,
lineorder 
where lo_orderkey > 0      and lo_custkey = c3_um.c_custkey
and lo_partkey = p2_um.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p1.p_partkey
and lo_partkey = p3.p_partkey
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and d2.d_year = 1994
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and p3.p_category <= 'MFGR#13'
       ;
count(*)
48792
select count(*)
from     customer c4,
part p1,
dateinfo d1,
part p2_um,
part p4_um,
lineorder 
where lo_orderkey > 0      and lo_custkey = c4.c_custkey
and lo_partkey = p1.p_partkey
and lo_orderdate = d1.d_datekey
and lo_partkey = p2_um.p_partkey
and lo_partkey = p4_um.p_partkey
and c4.c_region in ('EUROPE')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and p4_um.p_category <= 'MFGR#13'
       ;
count(*)
5464
select count(*)
from     part p1,
customer c4,
supplier s2,
part p3,
supplier s1,
lineorder 
where lo_orderkey > 0      and lo_partkey = p1.p_partkey
and lo_custkey = c4.c_custkey
and lo_suppkey = s2.s_suppkey
and lo_partkey = p3.p_partkey
and lo_suppkey = s1.s_suppkey
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and c4.c_region in ('EUROPE')
and s2.s_city in ('ALGERIA  0','ALGERIA  1','ALGERIA  2','GERMANY  0','GERMANY  1','UNITED KI2','UNITED KI3')
and p3.p_category <= 'MFGR#13'
    and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
;
count(*)
1705
select count(*)
from     part p2_um,
customer c3_um,
supplier s1,
part p4_um,
supplier s2,
lineorder 
where lo_orderkey > 0      and lo_partkey = p2_um.p_partkey
and lo_custkey = c3_um.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_partkey = p4_um.p_partkey
and lo_suppkey = s2.s_suppkey
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and p4_um.p_category <= 'MFGR#13'
    and s2.s_city in ('ALGERIA  0','ALGERIA  1','ALGERIA  2','GERMANY  0','GERMANY  1','UNITED KI2','UNITED KI3')
;
count(*)
5080
select count(*)
from     part p3,
customer c2_um,
part p4_um,
supplier s1,
dateinfo d1,
lineorder 
where lo_orderkey > 0      and lo_partkey = p3.p_partkey
and lo_custkey = c2_um.c_custkey
and lo_partkey = p4_um.p_partkey
and lo_suppkey = s1.s_suppkey
and lo_orderdate = d1.d_datekey
and p3.p_category <= 'MFGR#13'
    and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and p4_um.p_category <= 'MFGR#13'
    and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
;
count(*)
8792
select count(*)
from     part p4_um,
customer c1,
part p3,
supplier s2,
dateinfo d2,
lineorder 
where lo_orderkey > 0      and lo_partkey = p4_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_partkey = p3.p_partkey
and lo_suppkey = s2.s_suppkey
and lo_orderdate = d2.d_datekey
and p4_um.p_category <= 'MFGR#13'
    and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p3.p_category <= 'MFGR#13'
    and s2.s_city in ('ALGERIA  0','ALGERIA  1','ALGERIA  2','GERMANY  0','GERMANY  1','UNITED KI2','UNITED KI3')
and d2.d_year = 1994
;
count(*)
1114
select count(*)
from     supplier s1,
dateinfo d2,
part p2_um,
dateinfo d1,
customer c1,
lineorder 
where lo_orderkey > 0      and lo_suppkey = s1.s_suppkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p2_um.p_partkey
and lo_orderdate = d1.d_datekey
and lo_custkey = c1.c_custkey
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and d2.d_year = 1994
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
;
count(*)
9884
select count(*)
from     supplier s2,
dateinfo d1,
part p1,
dateinfo d2,
customer c2_um,
lineorder 
where lo_orderkey > 0      and lo_suppkey = s2.s_suppkey
and lo_orderdate = d1.d_datekey
and lo_partkey = p1.p_partkey
and lo_orderdate = d2.d_datekey
and lo_custkey = c2_um.c_custkey
and s2.s_city in ('ALGERIA  0','ALGERIA  1','ALGERIA  2','GERMANY  0','GERMANY  1','UNITED KI2','UNITED KI3')
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and d2.d_year = 1994
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
;
count(*)
510
select count(*)
from     dateinfo d1,
part p3,
customer c4,
customer c1,
customer c3_um,
lineorder 
where lo_orderkey > 0      and lo_orderdate = d1.d_datekey
and lo_partkey = p3.p_partkey
and lo_custkey = c4.c_custkey
and lo_custkey = c1.c_custkey
and lo_custkey = c3_um.c_custkey
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and p3.p_category <= 'MFGR#13'
    and c4.c_region in ('EUROPE')
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
;
count(*)
4497
select count(*)
from     dateinfo d2,
part p2_um,
customer c3_um,
customer c2_um,
customer c4,
lineorder 
where lo_orderkey > 0      and lo_orderdate = d2.d_datekey
and lo_partkey = p2_um.p_partkey
and lo_custkey = c3_um.c_custkey
and lo_custkey = c2_um.c_custkey
and lo_custkey = c4.c_custkey
and d2.d_year = 1994
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and c4.c_region in ('EUROPE')
;
count(*)
17224
select count(*)
from     customer c1,
part p1,
customer c2_um,
customer c3_um,
part p2_um,
lineorder 
where lo_orderkey > 0      and lo_custkey = c1.c_custkey
and lo_partkey = p1.p_partkey
and lo_custkey = c2_um.c_custkey
and lo_custkey = c3_um.c_custkey
and lo_partkey = p2_um.p_partkey
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
;
count(*)
215552
select count(*)
from     customer c2_um,
customer c4,
customer c1,
part p1,
part p2_um,
lineorder 
where lo_orderkey > 0      and lo_custkey = c2_um.c_custkey
and lo_custkey = c4.c_custkey
and lo_custkey = c1.c_custkey
and lo_partkey = p1.p_partkey
and lo_partkey = p2_um.p_partkey
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and c4.c_region in ('EUROPE')
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
;
count(*)
108385
select count(*)
from     customer c3_um,
customer c4,
dateinfo d2,
part p2_um,
part p3,
lineorder 
where lo_orderkey > 0      and lo_custkey = c3_um.c_custkey
and lo_custkey = c4.c_custkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p2_um.p_partkey
and lo_partkey = p3.p_partkey
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and c4.c_region in ('EUROPE')
and d2.d_year = 1994
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and p3.p_category <= 'MFGR#13'
       ;
count(*)
16929
select count(*)
from     customer c4,
customer c3_um,
dateinfo d1,
part p3,
part p4_um,
lineorder 
where lo_orderkey > 0      and lo_custkey = c4.c_custkey
and lo_custkey = c3_um.c_custkey
and lo_orderdate = d1.d_datekey
and lo_partkey = p3.p_partkey
and lo_partkey = p4_um.p_partkey
and c4.c_region in ('EUROPE')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and p3.p_category <= 'MFGR#13'
    and p4_um.p_category <= 'MFGR#13'
       ;
count(*)
7368
select count(*)
from     part p1,
customer c2_um,
supplier s2,
part p4_um,
supplier s1,
lineorder 
where lo_orderkey > 0      and lo_partkey = p1.p_partkey
and lo_custkey = c2_um.c_custkey
and lo_suppkey = s2.s_suppkey
and lo_partkey = p4_um.p_partkey
and lo_suppkey = s1.s_suppkey
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
and s2.s_city in ('ALGERIA  0','ALGERIA  1','ALGERIA  2','GERMANY  0','GERMANY  1','UNITED KI2','UNITED KI3')
and p4_um.p_category <= 'MFGR#13'
    and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
;
count(*)
3339
select count(*)
from     part p2_um,
customer c1,
supplier s1,
supplier s2,
dateinfo d1,
lineorder 
where lo_orderkey > 0      and lo_partkey = p2_um.p_partkey
and lo_custkey = c1.c_custkey
and lo_suppkey = s1.s_suppkey
and lo_suppkey = s2.s_suppkey
and lo_orderdate = d1.d_datekey
and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and s2.s_city in ('ALGERIA  0','ALGERIA  1','ALGERIA  2','GERMANY  0','GERMANY  1','UNITED KI2','UNITED KI3')
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
;
count(*)
242
select count(*)
from     part p3,
dateinfo d2,
part p4_um,
dateinfo d1,
customer c1,
lineorder 
where lo_orderkey > 0      and lo_partkey = p3.p_partkey
and lo_orderdate = d2.d_datekey
and lo_partkey = p4_um.p_partkey
and lo_orderdate = d1.d_datekey
and lo_custkey = c1.c_custkey
and p3.p_category <= 'MFGR#13'
    and d2.d_year = 1994
and p4_um.p_category <= 'MFGR#13'
    and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and c1.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','GERMANY','ROMANIA')
;
count(*)
12962
select count(*)
from     part p4_um,
supplier s2,
part p3,
dateinfo d2,
customer c2_um,
lineorder 
where lo_orderkey > 0      and lo_partkey = p4_um.p_partkey
and lo_suppkey = s2.s_suppkey
and lo_partkey = p3.p_partkey
and lo_orderdate = d2.d_datekey
and lo_custkey = c2_um.c_custkey
and p4_um.p_category <= 'MFGR#13'
    and s2.s_city in ('ALGERIA  0','ALGERIA  1','ALGERIA  2','GERMANY  0','GERMANY  1','UNITED KI2','UNITED KI3')
and p3.p_category <= 'MFGR#13'
    and d2.d_year = 1994
and c2_um.c_nation in ('MOROCCO','RUSSIA','MOZAMBIQUE','EGYPT','JAPAN','IRAQ','BRAZIL','INDONESIA','GERMANY','ROMANIA')
;
count(*)
1239
select count(*)
from     supplier s1,
part p4_um,
part p2_um,
dateinfo d1,
customer c3_um,
lineorder 
where lo_orderkey > 0      and lo_suppkey = s1.s_suppkey
and lo_partkey = p4_um.p_partkey
and lo_partkey = p2_um.p_partkey
and lo_orderdate = d1.d_datekey
and lo_custkey = c3_um.c_custkey
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and p4_um.p_category <= 'MFGR#13'
    and p2_um.p_mfgr <= 'MFGR#1' and p2_um.p_size <= 38
and d1.d_yearmonth in ('Jan1994','Feb1994','Mar1994','Apr1994')
and c3_um.c_region in ('EUROPE','MIDDLE EAST','ASIA')
;
count(*)
10025
select count(*)
from     supplier s2,
supplier s1,
part p1,
dateinfo d2,
customer c4,
lineorder 
where lo_orderkey > 0      and lo_suppkey = s2.s_suppkey
and lo_suppkey = s1.s_suppkey
and lo_partkey = p1.p_partkey
and lo_orderdate = d2.d_datekey
and lo_custkey = c4.c_custkey
and s2.s_city in ('ALGERIA  0','ALGERIA  1','ALGERIA  2','GERMANY  0','GERMANY  1','UNITED KI2','UNITED KI3')
and s1.s_region in ('EUROPE','MIDDLE EAST','ASIA')
and p1.p_mfgr <= 'MFGR#1' and p1.p_size <= 37
and d2.d_year = 1994
and c4.c_region in ('EUROPE')
;
count(*)
424