USE tpch1;
select count(*) from region a inner join nation b on (a.r_regionkey=b.n_regionkey) right outer join customer c on (b.n_name and b.n_nationkey = c.c_nationkey);
count(*)
150000
select * from region where r_regionkey;
r_regionkey	r_name	r_comment
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