Thomson Reuters interview question

To write out some SQL statements.