USE tpch1;
select n_name from nation where locate('A', n_name, 4) > 0 order by 1;
n_name
ALGERIA
ARGENTINA
CANADA
CHINA
ETHIOPIA
GERMANY
INDIA
INDONESIA
JAPAN
JORDAN
KENYA
MOZAMBIQUE
ROMANIA
RUSSIA
SAUDI ARABIA
UNITED STATES
VIETNAM
select n_name from nation where locate('A', n_name) > 0 order by 1;
n_name
ALGERIA
ARGENTINA
BRAZIL
CANADA
CHINA
ETHIOPIA
FRANCE
GERMANY
INDIA
INDONESIA
IRAN
IRAQ
JAPAN
JORDAN
KENYA
MOZAMBIQUE
ROMANIA
RUSSIA
SAUDI ARABIA
UNITED STATES
VIETNAM