我有一张数据如下的表:
Meal ID | Child | Fruit
1 Child A Apple
2 Child B Orange
3 Child A Banana
4 Child A Orange
5 Child C Banana
6 Child A Banana
7 Child C Banana
8 Child A Banana
,我需要根据所吃的水果(例如如果搜索查询是“香蕉”,结果将显示如下:
Banana Eaters (Highest to Lowest)
Child | Number of Bananas eaten
Child A 3
Child C 1
我将从:
开始 $sql = "SELECT * FROM meals WHERE Fruit = 'Banana'";
但是我该如何将吃香蕉的独特个体作为自己的条目,然后按食用最多的香蕉排序结果?