USE tpch1;
select if(sum(r_regionkey)>1, r_name, r_regionkey) from region group by r_name, r_regionkey order by 1;
if(sum(r_regionkey)>1, r_name, r_regionkey)
0
1
ASIA
EUROPE
MIDDLE EAST