American Express interview question

Some basic SQL table joins questions