How to create query in dynamics 365?

In Dynamics 365, you can create a query from Visual studio

just open visual studio and create a project

add new item

select data model in dynamics 365 items and choose query item

set query name and click the add button

I create a query on  DirPartyLocation table

right click on the data source and add new

select your table

and don't forget to set the dynamic fields property to yes

you can add ranges for your data source based on your demand

also, you can join another data source

you can set relation to yes or create manual relations, also set your join.

to create a manual relation, you must set relation property to no 

also, you can retrieve data from all legal entities, just set cross company to YES for this Query

also, you can group by field or order by ... etc

finally, build your solution.