translate query sql in dynamics ax

hello,

i need to write this query in ax, not whit query object but simple query by select etc etc…