American Express Interview Question

In SQL, what are the different types of joins? What is a subquery?