group them to have the same average

[Jiaxin]

Hi, I need help with this.

If I have a table, in the database containing fruits, price, quantity.

I want to arrange the price of the fruits into 3 groups of around the same average. Is it possible?

Thank you

[rocknbil]

You probably only need mysql, order by and avg().

select table.username, avg(score) as average from table group by table.title order by avg(score) asc;

May give you syntax errors but that's the direction to move in.

avg() [dev.mysql.com]

[Jiaxin]

Yeah, i did have that. and i created array. im stuck after that =/

[rocknbil]

Why did you need to create an array? That might be where it's getting mixed up. Does the data output raw from mysql in the correct order?