Pergunta de entrevista da empresa American Express

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