USE tpch1;
select n_nationkey, case when n_nationkey xor n_regionkey then 1 else 0 end case_xor from nation;
n_nationkey	case_xor
0	0
1	0
2	0
3	0
4	0
5	1
6	0
7	0
8	0
9	0
10	0
11	0
12	0
13	0
14	1
15	1
16	1
17	0
18	0
19	0
20	0
21	0
22	0
23	0
24	0
select n_nationkey, if(n_nationkey xor n_regionkey, 1, 0) from nation;
n_nationkey	if(n_nationkey xor n_regionkey, 1, 0)
0	0
1	0
2	0
3	0
4	0
5	1
6	0
7	0
8	0
9	0
10	0
11	0
12	0
13	0
14	1
15	1
16	1
17	0
18	0
19	0
20	0
21	0
22	0
23	0
24	0
select n_nationkey, if(n_nationkey and n_regionkey, 1, 0) from nation;
n_nationkey	if(n_nationkey and n_regionkey, 1, 0)
0	0
1	1
2	1
3	1
4	1
5	0
6	1
7	1
8	1
9	1
10	1
11	1
12	1
13	1
14	0
15	0
16	0
17	1
18	1
19	1
20	1
21	1
22	1
23	1
24	1
select n_nationkey, case when n_nationkey or n_regionkey then 1 else 0 end case_xor from nation;
n_nationkey	case_xor
0	0
1	1
2	1
3	1
4	1
5	1
6	1
7	1
8	1
9	1
10	1
11	1
12	1
13	1
14	1
15	1
16	1
17	1
18	1
19	1
20	1
21	1
22	1
23	1
24	1