CME interview question

SQL question to design and create some SQL statements based on Entity-Relationship diagram