Macquarie Group interview question

Construct database and write SQL queries