SQLite 3.27

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

CREATE TABLE IF NOT EXISTS fruit_eaten (
    eater_name varchar(255) NOT NULL,
    fruit_name varchar(255) NOT NULL
);
✓
INSERT INTO fruit_eaten VALUES
  ('bob', 'Apple'), 
  ('bobby', 'Orange'), 
  ('bobbi', 'Apple'), 
  ('boy', 'Grape'), 
  ('bobthebuilder', 'Orange');
✓
SELECT fruit_name,
       COUNT(*) AS number_of_eaters
FROM fruit_eaten
GROUP BY fruit_name
ORDER BY number_of_eaters DESC, fruit_name;


fruit_name
number_of_eaters


Apple
2

Orange
2

Grape
1


INSERT INTO fruit_eaten VALUES
  ('Bobushka', 'Orange');
✓
SELECT fruit_name,
       COUNT(*) AS number_of_eaters
FROM fruit_eaten
GROUP BY fruit_name
ORDER BY number_of_eaters DESC, fruit_name;


fruit_name
number_of_eaters


Orange
3

Apple
2

Grape
1

`fruit_name`	`number_of_eaters`
`Apple`	`2`
`Orange`	`2`
`Grape`	`1`

`fruit_name`	`number_of_eaters`
`Orange`	`3`
`Apple`	`2`
`Grape`	`1`