Ipreo interview question

Write a SQL statement that...