State Street interview question

They asked me for an SQL query that uses an inner join structure.