Pregunta de entrevista de CME Group

SQL basic: different type of join and condition