带计数的SQL Server查询返回null或无结果

I have the following query:

我有以下查询：

SELECT Centre.Centre_Name, Count(Shop_No) AS shopcount FROM Centre INNER JOIN Space ON Centre.Centre_Name = Space.Centre_Name GROUP BY Centre.Centre_Name
SELECT