Need to write query entity for one scenario

Hi,

I need query entity model for below scenario.

I have one database table. It has request number, application name, ID, etc., Every request number has one application. But every application has many request numbers. For Eg., XYZ0001 - Appian. But Appian - XYZ0001, XYZ0002., I need to display all the latest request number and all remaining fields in each application in report.

For Eg.,

Appian: XYZ0002

ABC: XYZ0008

Application count also dynamic. Application count can change in any time like if we create new request with new application name, we need to add this new application name in that report with request number.

Thanks for your help!