USE outerjoin;
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 join nation n2 on n1.n_nationkey = n2.n_nationkey;
n_nationkey	n_nationkey	n_nationkey	n_name	n_regionkey	n_comment	n_nationkey	n_name	n_regionkey	n_comment
-1	-1	-1	ARGENTINA	-100	al foxes promise slyly according to the regular accounts. bold requests alon	-1	ARGENTINA	-100	al foxes promise slyly according to the regular accounts. bold requests alon
-2	-2	-2	BRAZIL	-100	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 	-2	BRAZIL	-100	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 
-3	-3	-3	CANADA	-100	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold	-3	CANADA	-100	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
0	0	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai
1	1	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon
10	10	10	IRAN	4	efully alongside of the slyly final dependencies. 	10	IRAN	4	efully alongside of the slyly final dependencies. 
11	11	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula
12	12	12	JAPAN	2	ously. final, express gifts cajole a	12	JAPAN	2	ously. final, express gifts cajole a
13	13	13	JORDAN	4	ic deposits are blithely about the carefully regular pa	13	JORDAN	4	ic deposits are blithely about the carefully regular pa
14	14	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t
15	15	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?
16	16	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r
17	17	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun
18	18	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos
19	19	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account
2	2	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 
20	20	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely
21	21	21	VIETNAM	2	hely enticingly express accounts. even, final 	21	VIETNAM	2	hely enticingly express accounts. even, final 
22	22	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint
23	23	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull
24	24	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be
3	3	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
4	4	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d
5	5	5	ETHIOPIA	0	ven packages wake quickly. regu	5	ETHIOPIA	0	ven packages wake quickly. regu
6	6	6	FRANCE	3	refully final requests. regular, ironi	6	FRANCE	3	refully final requests. regular, ironi
7	7	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco
8	8	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun
9	9	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 left  join nation n2 on n1.n_nationkey = n2.n_nationkey;
n_nationkey	n_nationkey	n_nationkey	n_name	n_regionkey	n_comment	n_nationkey	n_name	n_regionkey	n_comment
-1	-1	-1	ARGENTINA	-100	al foxes promise slyly according to the regular accounts. bold requests alon	-1	ARGENTINA	-100	al foxes promise slyly according to the regular accounts. bold requests alon
-2	-2	-2	BRAZIL	-100	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 	-2	BRAZIL	-100	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 
-3	-3	-3	CANADA	-100	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold	-3	CANADA	-100	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
0	0	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai
1	1	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon
10	10	10	IRAN	4	efully alongside of the slyly final dependencies. 	10	IRAN	4	efully alongside of the slyly final dependencies. 
11	11	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula
12	12	12	JAPAN	2	ously. final, express gifts cajole a	12	JAPAN	2	ously. final, express gifts cajole a
13	13	13	JORDAN	4	ic deposits are blithely about the carefully regular pa	13	JORDAN	4	ic deposits are blithely about the carefully regular pa
14	14	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t
15	15	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?
16	16	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r
17	17	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun
18	18	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos
19	19	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account
2	2	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 
20	20	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely
21	21	21	VIETNAM	2	hely enticingly express accounts. even, final 	21	VIETNAM	2	hely enticingly express accounts. even, final 
22	22	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint
23	23	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull
24	24	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be
3	3	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
4	4	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d
5	5	5	ETHIOPIA	0	ven packages wake quickly. regu	5	ETHIOPIA	0	ven packages wake quickly. regu
6	6	6	FRANCE	3	refully final requests. regular, ironi	6	FRANCE	3	refully final requests. regular, ironi
7	7	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco
8	8	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun
9	9	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull
NULL	NULL	NULL	ARGENTINA	NULL	al foxes promise slyly according to the regular accounts. bold requests alon	NULL	NULL	NULL	NULL
NULL	NULL	NULL	BRAZIL	NULL	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 	NULL	NULL	NULL	NULL
NULL	NULL	NULL	CANADA	NULL	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold	NULL	NULL	NULL	NULL
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 right join nation n2 on n1.n_nationkey = n2.n_nationkey;
n_nationkey	n_nationkey	n_nationkey	n_name	n_regionkey	n_comment	n_nationkey	n_name	n_regionkey	n_comment
-1	-1	-1	ARGENTINA	-100	al foxes promise slyly according to the regular accounts. bold requests alon	-1	ARGENTINA	-100	al foxes promise slyly according to the regular accounts. bold requests alon
-2	-2	-2	BRAZIL	-100	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 	-2	BRAZIL	-100	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 
-3	-3	-3	CANADA	-100	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold	-3	CANADA	-100	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
0	0	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai
1	1	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon
10	10	10	IRAN	4	efully alongside of the slyly final dependencies. 	10	IRAN	4	efully alongside of the slyly final dependencies. 
11	11	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula
12	12	12	JAPAN	2	ously. final, express gifts cajole a	12	JAPAN	2	ously. final, express gifts cajole a
13	13	13	JORDAN	4	ic deposits are blithely about the carefully regular pa	13	JORDAN	4	ic deposits are blithely about the carefully regular pa
14	14	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t
15	15	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?
16	16	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r
17	17	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun
18	18	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos
19	19	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account
2	2	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 
20	20	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely
21	21	21	VIETNAM	2	hely enticingly express accounts. even, final 	21	VIETNAM	2	hely enticingly express accounts. even, final 
22	22	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint
23	23	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull
24	24	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be
3	3	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
4	4	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d
5	5	5	ETHIOPIA	0	ven packages wake quickly. regu	5	ETHIOPIA	0	ven packages wake quickly. regu
6	6	6	FRANCE	3	refully final requests. regular, ironi	6	FRANCE	3	refully final requests. regular, ironi
7	7	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco
8	8	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun
9	9	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull
NULL	NULL	NULL	NULL	NULL	NULL	NULL	ARGENTINA	NULL	al foxes promise slyly according to the regular accounts. bold requests alon
NULL	NULL	NULL	NULL	NULL	NULL	NULL	BRAZIL	NULL	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 
NULL	NULL	NULL	NULL	NULL	NULL	NULL	CANADA	NULL	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 join nation n2 on n1.n_nationkey = n2.n_nationkey where n1.n_nationkey >= 0;
n_nationkey	n_nationkey	n_nationkey	n_name	n_regionkey	n_comment	n_nationkey	n_name	n_regionkey	n_comment
0	0	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai
1	1	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon
10	10	10	IRAN	4	efully alongside of the slyly final dependencies. 	10	IRAN	4	efully alongside of the slyly final dependencies. 
11	11	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula
12	12	12	JAPAN	2	ously. final, express gifts cajole a	12	JAPAN	2	ously. final, express gifts cajole a
13	13	13	JORDAN	4	ic deposits are blithely about the carefully regular pa	13	JORDAN	4	ic deposits are blithely about the carefully regular pa
14	14	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t
15	15	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?
16	16	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r
17	17	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun
18	18	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos
19	19	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account
2	2	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 
20	20	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely
21	21	21	VIETNAM	2	hely enticingly express accounts. even, final 	21	VIETNAM	2	hely enticingly express accounts. even, final 
22	22	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint
23	23	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull
24	24	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be
3	3	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
4	4	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d
5	5	5	ETHIOPIA	0	ven packages wake quickly. regu	5	ETHIOPIA	0	ven packages wake quickly. regu
6	6	6	FRANCE	3	refully final requests. regular, ironi	6	FRANCE	3	refully final requests. regular, ironi
7	7	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco
8	8	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun
9	9	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 left  join nation n2 on n1.n_nationkey = n2.n_nationkey where n1.n_nationkey >= 0;
n_nationkey	n_nationkey	n_nationkey	n_name	n_regionkey	n_comment	n_nationkey	n_name	n_regionkey	n_comment
0	0	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai
1	1	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon
10	10	10	IRAN	4	efully alongside of the slyly final dependencies. 	10	IRAN	4	efully alongside of the slyly final dependencies. 
11	11	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula
12	12	12	JAPAN	2	ously. final, express gifts cajole a	12	JAPAN	2	ously. final, express gifts cajole a
13	13	13	JORDAN	4	ic deposits are blithely about the carefully regular pa	13	JORDAN	4	ic deposits are blithely about the carefully regular pa
14	14	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t
15	15	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?
16	16	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r
17	17	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun
18	18	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos
19	19	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account
2	2	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 
20	20	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely
21	21	21	VIETNAM	2	hely enticingly express accounts. even, final 	21	VIETNAM	2	hely enticingly express accounts. even, final 
22	22	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint
23	23	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull
24	24	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be
3	3	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
4	4	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d
5	5	5	ETHIOPIA	0	ven packages wake quickly. regu	5	ETHIOPIA	0	ven packages wake quickly. regu
6	6	6	FRANCE	3	refully final requests. regular, ironi	6	FRANCE	3	refully final requests. regular, ironi
7	7	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco
8	8	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun
9	9	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 left  join nation n2 on n1.n_nationkey = n2.n_nationkey where n2.n_nationkey >= 0;
n_nationkey	n_nationkey	n_nationkey	n_name	n_regionkey	n_comment	n_nationkey	n_name	n_regionkey	n_comment
0	0	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai
1	1	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon
10	10	10	IRAN	4	efully alongside of the slyly final dependencies. 	10	IRAN	4	efully alongside of the slyly final dependencies. 
11	11	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula
12	12	12	JAPAN	2	ously. final, express gifts cajole a	12	JAPAN	2	ously. final, express gifts cajole a
13	13	13	JORDAN	4	ic deposits are blithely about the carefully regular pa	13	JORDAN	4	ic deposits are blithely about the carefully regular pa
14	14	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t
15	15	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?
16	16	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r
17	17	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun
18	18	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos
19	19	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account
2	2	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 
20	20	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely
21	21	21	VIETNAM	2	hely enticingly express accounts. even, final 	21	VIETNAM	2	hely enticingly express accounts. even, final 
22	22	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint
23	23	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull
24	24	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be
3	3	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
4	4	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d
5	5	5	ETHIOPIA	0	ven packages wake quickly. regu	5	ETHIOPIA	0	ven packages wake quickly. regu
6	6	6	FRANCE	3	refully final requests. regular, ironi	6	FRANCE	3	refully final requests. regular, ironi
7	7	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco
8	8	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun
9	9	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 right join nation n2 on n1.n_nationkey = n2.n_nationkey where n1.n_nationkey >= 0;
n_nationkey	n_nationkey	n_nationkey	n_name	n_regionkey	n_comment	n_nationkey	n_name	n_regionkey	n_comment
0	0	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai
1	1	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon
10	10	10	IRAN	4	efully alongside of the slyly final dependencies. 	10	IRAN	4	efully alongside of the slyly final dependencies. 
11	11	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula
12	12	12	JAPAN	2	ously. final, express gifts cajole a	12	JAPAN	2	ously. final, express gifts cajole a
13	13	13	JORDAN	4	ic deposits are blithely about the carefully regular pa	13	JORDAN	4	ic deposits are blithely about the carefully regular pa
14	14	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t
15	15	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?
16	16	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r
17	17	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun
18	18	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos
19	19	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account
2	2	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 
20	20	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely
21	21	21	VIETNAM	2	hely enticingly express accounts. even, final 	21	VIETNAM	2	hely enticingly express accounts. even, final 
22	22	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint
23	23	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull
24	24	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be
3	3	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
4	4	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d
5	5	5	ETHIOPIA	0	ven packages wake quickly. regu	5	ETHIOPIA	0	ven packages wake quickly. regu
6	6	6	FRANCE	3	refully final requests. regular, ironi	6	FRANCE	3	refully final requests. regular, ironi
7	7	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco
8	8	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun
9	9	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 right join nation n2 on n1.n_nationkey = n2.n_nationkey where n2.n_nationkey >= 0;
n_nationkey	n_nationkey	n_nationkey	n_name	n_regionkey	n_comment	n_nationkey	n_name	n_regionkey	n_comment
0	0	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai	0	ALGERIA	0	 haggle. carefully final deposits detect slyly agai
1	1	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon	1	ARGENTINA	1	al foxes promise slyly according to the regular accounts. bold requests alon
10	10	10	IRAN	4	efully alongside of the slyly final dependencies. 	10	IRAN	4	efully alongside of the slyly final dependencies. 
11	11	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula	11	IRAQ	4	nic deposits boost atop the quickly final requests? quickly regula
12	12	12	JAPAN	2	ously. final, express gifts cajole a	12	JAPAN	2	ously. final, express gifts cajole a
13	13	13	JORDAN	4	ic deposits are blithely about the carefully regular pa	13	JORDAN	4	ic deposits are blithely about the carefully regular pa
14	14	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t	14	KENYA	0	 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t
15	15	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?	15	MOROCCO	0	rns. blithely bold courts among the closely regular packages use furiously bold platelets?
16	16	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r	16	MOZAMBIQUE	0	s. ironic, unusual asymptotes wake blithely r
17	17	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun	17	PERU	1	platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun
18	18	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos	18	CHINA	2	c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos
19	19	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account	19	ROMANIA	3	ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account
2	2	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 	2	BRAZIL	1	y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special 
20	20	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely	20	SAUDI ARABIA	4	ts. silent requests haggle. closely express packages sleep across the blithely
21	21	21	VIETNAM	2	hely enticingly express accounts. even, final 	21	VIETNAM	2	hely enticingly express accounts. even, final 
22	22	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint	22	RUSSIA	3	 requests against the platelets use never according to the quickly regular pint
23	23	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull	23	UNITED KINGDOM	3	eans boost carefully special requests. accounts are. carefull
24	24	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be	24	UNITED STATES	1	y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be
3	3	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold	3	CANADA	1	eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
4	4	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d	4	EGYPT	4	y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d
5	5	5	ETHIOPIA	0	ven packages wake quickly. regu	5	ETHIOPIA	0	ven packages wake quickly. regu
6	6	6	FRANCE	3	refully final requests. regular, ironi	6	FRANCE	3	refully final requests. regular, ironi
7	7	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco	7	GERMANY	3	l platelets. regular accounts x-ray: unusual, regular acco
8	8	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun	8	INDIA	2	ss excuses cajole slyly across the packages. deposits print aroun
9	9	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull	9	INDONESIA	2	 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull