Pergunta de entrevista da empresa Shell

List the types of join in sql and briefly explain how they work.