It depends on how the data is organized.
For the example, one would expect the data to go in a least two separate tables: one for Salesone ID information, another for order information. In which case the answer is trivial.
The challenge implies that the intent is to repeat the Salesone ID in every record in a single table, hardly good relational practice.
Keep Up with TechRepublic