CME Group interview question

Do you know how to do a join statement in sql