database/mariadb-columnstore-engine
1
0
Fork 0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-07-29 08:21:15 +03:00
Code Activity
Files
mcol-5328-regexp-substr
mariadb-columnstore-engine/mysql-test/columnstore/autopilot/r/mcs6893_outerjoin_twoTables.result
Daniel Lee 4c9d6e39ac Dlee mtr restructure (#2494) 
* Restructured test suites and added autopilot and extended suites

* Updated autopilot with correct branch - develop

* Moved setup test case to a 'setup' directory, for consistency

* Fixed a path issue

* Updated some tests cases to keep up with development

Co-authored-by: root <root@rocky8.localdomain>
2022-08-09 21:20:56 +03:00

508 lines
78 KiB
Plaintext
Raw Permalink Blame History

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