Alimentiv Interview Question

How would you format a query for this specific situation