DV Trading interview question

understand sql: joins, select etc.