MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE meals (
  `Meal ID` INTEGER,
  `Child` VARCHAR(7),
  `Fruit` VARCHAR(6)
);

INSERT INTO meals
  (`Meal ID`, `Child`, `Fruit`)
VALUES
  ('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');
select child, sum(fruit = 'Banana') `Number of Bananas eaten`
from meals
group by child
order by `Number of Bananas eaten` desc 


child
Number of Bananas eaten


Child A
3

Child C
2

Child B
0


select child, sum(fruit = 'Banana') `Number of Bananas eaten`
from meals
group by child
having `Number of Bananas eaten` > 0
order by `Number of Bananas eaten` desc 


child
Number of Bananas eaten


Child A
3

Child C
2