SQLite 3.39

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

CREATE TABLE businesses (id INTEGER PRIMARY KEY, name TEXT NOT NULL, city TEXT NOT NULL, owner TEXT NOT NULL);
✓
INSERT INTO businesses (id, name, city, owner) VALUES
    (1, 'Shop A', 'London', 'Tom'),
    (2, 'Shop B', 'London', 'Tom'),
    (3, 'Shop C', 'London', 'Tom'),
    (4, 'Shop D', 'Luton', 'Alice'),
    (5, 'Shop E', 'Leeds', 'Jenny'),
    (6, 'Shop F', 'Leicester', 'James'),
    (7, 'Shop G', 'Leicester', 'James'),
    (8, 'Shop H', 'Leicester', 'Emma'),
    (9, 'Shop I', 'Leicester', 'Emma'),
    (10, 'Shop J', 'Liverpool', 'James'),
    (11, 'Shop K', 'Liverpool', 'James'),
    (12, 'Shop L', 'Liverpool', 'George'),
    (13, 'Shop M', 'Shefield', 'Mary'),
    (14, 'Shop N', 'Shefield', 'Mary'),
    (15, 'Shop O', 'Cambridge', 'Oliver'),
    (16, 'Shop P', 'Manchester', 'Harry');
✓
SELECT DISTINCT city, 
       SUM(COUNT(*)) OVER (PARTITION By city) AS count
FROM businesses
GROUP BY city, owner
HAVING COUNT(*) >= 2
ORDER BY count DESC LIMIT 2;


city
count


Leicester
4

London
3

`city`	`count`
`Leicester`	`4`
`London`	`3`