USE tpch1;
select n_name from ((select n_name, n_regionkey from nation) union all
(select n_name, n_regionkey from nation)) as a order by 1;
n_name
ALGERIA
ALGERIA
ARGENTINA
ARGENTINA
BRAZIL
BRAZIL
CANADA
CANADA
CHINA
CHINA
EGYPT
EGYPT
ETHIOPIA
ETHIOPIA
FRANCE
FRANCE
GERMANY
GERMANY
INDIA
INDIA
INDONESIA
INDONESIA
IRAN
IRAN
IRAQ
IRAQ
JAPAN
JAPAN
JORDAN
JORDAN
KENYA
KENYA
MOROCCO
MOROCCO
MOZAMBIQUE
MOZAMBIQUE
PERU
PERU
ROMANIA
ROMANIA
RUSSIA
RUSSIA
SAUDI ARABIA
SAUDI ARABIA
UNITED KINGDOM
UNITED KINGDOM
UNITED STATES
UNITED STATES
VIETNAM
VIETNAM
select n_name from ((select n_name, n_regionkey from nation) union
(select n_name, n_regionkey from nation)) as a order by 1;
n_name
ALGERIA
ARGENTINA
BRAZIL
CANADA
CHINA
EGYPT
ETHIOPIA
FRANCE
GERMANY
INDIA
INDONESIA
IRAN
IRAQ
JAPAN
JORDAN
KENYA
MOROCCO
MOZAMBIQUE
PERU
ROMANIA
RUSSIA
SAUDI ARABIA
UNITED KINGDOM
UNITED STATES
VIETNAM
select a_name from ((select n_name as a_name from nation) union (select
n_name as a_name from nation)) as a order by 1;
a_name
ALGERIA
ARGENTINA
BRAZIL
CANADA
CHINA
EGYPT
ETHIOPIA
FRANCE
GERMANY
INDIA
INDONESIA
IRAN
IRAQ
JAPAN
JORDAN
KENYA
MOROCCO
MOZAMBIQUE
PERU
ROMANIA
RUSSIA
SAUDI ARABIA
UNITED KINGDOM
UNITED STATES
VIETNAM
select name1 from ((select n_name as name1, n_regionkey from nation)
union all (select n_name as name1, n_regionkey from nation)) as a order by 1;
name1
ALGERIA
ALGERIA
ARGENTINA
ARGENTINA
BRAZIL
BRAZIL
CANADA
CANADA
CHINA
CHINA
EGYPT
EGYPT
ETHIOPIA
ETHIOPIA
FRANCE
FRANCE
GERMANY
GERMANY
INDIA
INDIA
INDONESIA
INDONESIA
IRAN
IRAN
IRAQ
IRAQ
JAPAN
JAPAN
JORDAN
JORDAN
KENYA
KENYA
MOROCCO
MOROCCO
MOZAMBIQUE
MOZAMBIQUE
PERU
PERU
ROMANIA
ROMANIA
RUSSIA
RUSSIA
SAUDI ARABIA
SAUDI ARABIA
UNITED KINGDOM
UNITED KINGDOM
UNITED STATES
UNITED STATES
VIETNAM
VIETNAM
select a.a_name, a.regionkey from ((select n_name as a_name, n_regionkey
as regionkey from nation) union (select n_name as a_name, n_regionkey as
regionkey from nation)) as a order by 1, 2;
a_name	regionkey
ALGERIA	0
ARGENTINA	1
BRAZIL	1
CANADA	1
CHINA	2
EGYPT	4
ETHIOPIA	0
FRANCE	3
GERMANY	3
INDIA	2
INDONESIA	2
IRAN	4
IRAQ	4
JAPAN	2
JORDAN	4
KENYA	0
MOROCCO	0
MOZAMBIQUE	0
PERU	1
ROMANIA	3
RUSSIA	3
SAUDI ARABIA	4
UNITED KINGDOM	3
UNITED STATES	1
VIETNAM	2
select a_name from ((select n_name as a_name from nation) union all (select
n_name as a_name from nation)) as a order by 1;
a_name
ALGERIA
ALGERIA
ARGENTINA
ARGENTINA
BRAZIL
BRAZIL
CANADA
CANADA
CHINA
CHINA
EGYPT
EGYPT
ETHIOPIA
ETHIOPIA
FRANCE
FRANCE
GERMANY
GERMANY
INDIA
INDIA
INDONESIA
INDONESIA
IRAN
IRAN
IRAQ
IRAQ
JAPAN
JAPAN
JORDAN
JORDAN
KENYA
KENYA
MOROCCO
MOROCCO
MOZAMBIQUE
MOZAMBIQUE
PERU
PERU
ROMANIA
ROMANIA
RUSSIA
RUSSIA
SAUDI ARABIA
SAUDI ARABIA
UNITED KINGDOM
UNITED KINGDOM
UNITED STATES
UNITED STATES
VIETNAM
VIETNAM
select a.a_name, a.regionkey from ((select n_name as a_name, n_regionkey
as regionkey from nation) union all (select n_name as a_name, n_regionkey as
regionkey from nation)) as a order by 1, 2;
a_name	regionkey
ALGERIA	0
ALGERIA	0
ARGENTINA	1
ARGENTINA	1
BRAZIL	1
BRAZIL	1
CANADA	1
CANADA	1
CHINA	2
CHINA	2
EGYPT	4
EGYPT	4
ETHIOPIA	0
ETHIOPIA	0
FRANCE	3
FRANCE	3
GERMANY	3
GERMANY	3
INDIA	2
INDIA	2
INDONESIA	2
INDONESIA	2
IRAN	4
IRAN	4
IRAQ	4
IRAQ	4
JAPAN	2
JAPAN	2
JORDAN	4
JORDAN	4
KENYA	0
KENYA	0
MOROCCO	0
MOROCCO	0
MOZAMBIQUE	0
MOZAMBIQUE	0
PERU	1
PERU	1
ROMANIA	3
ROMANIA	3
RUSSIA	3
RUSSIA	3
SAUDI ARABIA	4
SAUDI ARABIA	4
UNITED KINGDOM	3
UNITED KINGDOM	3
UNITED STATES	1
UNITED STATES	1
VIETNAM	2
VIETNAM	2