SQL Group By including empty rows
For the sake of this question, let's suppose this table structure:

    People:
    PersonID int PK
    Name varchar(50)
    Place int NULL FK -> Places.PlaceID
    MovedIn datetime

    Places:
    PlaceID int PK
    Name varchar(50)

I want to determine how many people live at each place:

    SELECT pla.PlaceID, COUNT(*)
    FROM Places AS pla
    LEFT JOIN People as peo ON peo.PlaceID = pla.PlaceID

This query will omit places that have no people living there. Is there any way to make it count 0 instead?

(I'm targetting SQL Server 2005, in the off chance that it matters)
SQL Group By including empty rows
===

For the sake of this question, let's suppose this table structure:

    People:
    PersonID int PK
    Name varchar(50)
    Place int NULL FK -> Places.PlaceID
    MovedIn datetime

    Places:
    PlaceID int PK
    Name varchar(50)

I want to determine how many people live at each place:

    SELECT pla.PlaceID, COUNT(*)
    FROM Places AS pla
    LEFT JOIN People as peo ON peo.PlaceID = pla.PlaceID

This query will omit places that have no people living there. Is there any way to make it count 0 instead?

(I'm targetting SQL Server 2005, in the off chance that it matters)