American Express interview question

Basic questions about SQL like join, group by etc.