Pregunta de entrevista de Lowe's Home Improvement

How joins are used in SQL.