Pregunta de entrevista de XPO

How does the cross join worked in SQL? What does self join use in SQL?