Latest price agreement per part number per account

Summary:

In CPQ, for an Account having multiple trade agreements, how can we get the list of agreements that have the enddate >= Today then we need sort by startdate descending and limit 1

Content (please ensure you mask any confidential information):

In this way I will get the latest active price for that part number for this account.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):