Pergunta de entrevista da empresa CME Group

SQL basic: different type of join and condition