Walmart interview question

3. About SQL queries based on scenario