Blue Yonder interview question

Given an scenario and retrieve the data using SQL