Group by function in script

[#1]

Good morning,

I tried a simple script to get used to group by function, however, the script didn't run. Here is a screen shot of the script and the error message.
Can anyone tell me what is wrong.

Thank you all !

[jsanchezh]

I did this, but it works if you know a maximum number of products on each purchase

[#3]

Thank you a lot

[jsanchezh]

you can mark some of my answers as "useful" if you wish

[pratap6699]

Temp:

Load

Achat,

Produit,

prix,

debut,

fin

from C:\....;

Load

Achat,

Produit,

prix,

debut,

fin

avg(prix) as Avgprix

Resident Temp

Group By Achat,prodit,prix,debut,fin;