Sysco LABS interview question

Write sql queries for given scenarios