[Minor]: Add data based sort expression test

[akurmustafa]

Which issue does this PR close?

Closes #.

Rationale for this change

As in the discussion, sometimes theoretically deriving the sort expressions that can be deduced for given sort expressions is not trivial.

In this PR, I added a new util function to create a test data that satisfy given ordering expressions. After constructing the data, we can test our hypothesis on the constructed data.

I added the example in the comment as a test case.

What changes are included in this PR?

Are these changes tested?

Yes,

Are there any user-facing changes?