OpenText interview question

Simple Sql query, db design