American Express interview question

Questions on SQL and joins, union etc