You have to count only owners id with DISTINCT word, which counts only unique owners.
SELECT owners.city, count(DISTINCT owners.id) AS 'Owners'
FROM owners INNER JOIN dogs ON (owners.id = dogs.owner_id)
GROUP BY owners.city
1
solved Mysql Query [0001]