American Express Interview Question

Basic questions about SQL like join, group by etc.