[Solved] Mysql Query [0001]

by


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]