How to fix error select list with group by when i want to make the aggregate function

How to fix error select list with group by when i want to make the aggregate function

  

i want to make COUNT, SUM, and etc from Customer Entity. So, first step is Advanced SQL ? am i right ? If i'm wrong, please tell me the steps. I really need it.

I attached the file.oml to (Exercise1.oml)


Thanks for your help

Another better option, use aggregate, instead. 

regards,

bb

Barong Bali wrote:

Another better option, use aggregate, instead. 

regards,

bb

like this ?

fahmi fachrurozi wrote:

Barong Bali wrote:

Another better option, use aggregate, instead. 

regards,

bb

like this ?


but i have an error, please tell me

hi,