Sysco interview question

SQL queries on a given class diagram