Barings Interview Question

Question on how to write out a SQL query for pulling data.