DROP TABLE part;

-- data setup
CREATE TABLE part( 
    p_partkey INT,
    p_name STRING,
    p_mfgr STRING,
    p_brand STRING,
    p_type STRING,
    p_size INT,
    p_container STRING,
    p_retailprice DOUBLE,
    p_comment STRING
);

LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part;

create table part2( 
    p2_partkey INT,
    p2_name STRING,
    p2_mfgr STRING,
    p2_brand STRING,
    p2_type STRING,
    p2_size INT,
    p2_container STRING,
    p2_retailprice DOUBLE,
    p2_comment STRING
);

create table part3( 
    p3_partkey INT,
    p3_name STRING,
    p3_mfgr STRING,
    p3_brand STRING,
    p3_type STRING,
    p3_size INT,
    p3_container STRING,
    p3_retailprice DOUBLE,
    p3_comment STRING
);

explain select *
from part p1 join part2 p2 join part3 p3 
where p1.p_name = p2_name and p2_name = p3_name;

explain select *
from part p1 join part2 p2 join part3 p3 
where p2_name = p1.p_name and p3_name = p2_name;

explain select *
from part p1 join part2 p2 join part3 p3 
where p2_partkey + p1.p_partkey = p1.p_partkey and p3_name = p2_name;

explain select *
from part p1 join part2 p2 join part3 p3 
where p2_partkey = 1 and p3_name = p2_name;