Bank of America Interview Question

SQL questions about sub-queries and joining of two tables.