HIVE Triva
What keyword is used to remove a table and its metadata in HIVE?
What is 'Drop'?
What city is famous for its canals and gondolas?
Venice
What year was Amex founded?
1850
In pop and hip-hop culture, what is the nickname some artists use for our "Centurion Card" product in songs?
Black Card
CHT
Customer/Call Handling Time
What clause/keyword is used to remove duplicate rows in a query result?
What is 'Distinct'?
Which country has 11 official languages and hosted the 2010 FIFA World Cup?
South Africa
Which Amex initiative helps small businesses and takes place the Saturday after thanksgiving every year in the US?
Small Business Saturday
Which tennis legend has appeared in American Express commercials, including one titled "Don't Live Life Without It"?
Serena Williams
RTF
Recommend to a Friend
What would be the correct order to use the following clauses in a query? Group by, From, Where.
What is the longest river in the world that flows through 11 countries?
The Nile River
What is the name of Amex's in-house creative marketing agency?
On brand
What is the name of the soccer/football team that Amex sponsors?
Brighton and Hove Albion F.C.
Measures of Success
Which function returns the current data in timestamp format?
What is current_timestamp()?
What country is home to the most natural lakes in the world?
Canada
What company did Steve Squeri work for, prior to joining Amex?
Accenture
Amex partnered with what popular music festival to offer exclusive perks to cardmembers, including a special lounge?
Coachella
VIBES
Valuing Interactions by Evaluating Sentiment
How would you retrieve the top 10 highest paid employees in order from a table called employees with a salary column?
SELECT * FROM employees ORDER BY salary DESC Limit 10;
What is the busiest airport in the world by passenger traffic
Hartsfield-Jackson Atlanta International Airport
Name two of the three original founders of American Express
Henry Wells, William Fargo, John Butterfield
What famous Author would frequently visit the Amex London office in the early 20th century?
Mark Twain
YODA-P
Your Offline Data Analytics Platform