使用GROUP BY的复杂查询和MySQL中的价格范围

In my DB table, I have a lot of products (several of which the same product). If the product in table is e.g. 5 times, so first could be its price , then , , and .In my DB table, I have a lot of products (sever