CME Group interview question

SQL basic: different type of join and condition