CME Group Interview Question

SQL basic: different type of join and condition