Eric,

even easier:

SELECT SiteID, Count (*) as NumStations
from StationInfo
GROUP BY SiteID

since you don't seem to need any further fields from SiteInfo.

Luc.