I have 2 MySQL and I'm trying to get the number of owners who own at least one dog, for each city. My tables are:
owners
id, name, city
and
dogs
id, owner_id, name, weight
I have the following so far:
SELECT owners.city, count(dogs.id) AS 'Owners'
FROM owners INNER JOIN dogs ON (owners.id = dogs.owner_id)
GROUP BY owners.city
However, this gives me the total number of dogs per city. But I'd like to get the number of dog owners per city.
How should I do this?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…