Sysco LABS Interview Question

Write sql queries for given scenarios