SQL Statement Problem

See more:

SQL

SQL-Server

I'm new in SQL Server, i'm using SQL Server 2012, i have 2 tables Service and Project and each service may have one or more project, i tried to make a stored procedure that retrieve the service name and the number of projects related to this service, this my SQL Statement:

Create proc [dbo].[SP_ServiceProjectCount]
as
begin
SELECT s.ServiceName + '  ( '+ CAST( COUNT(p.ProjectID) as nvarchar(255)) + ' )' as ServiceName , s.ServiceID
FROM  Service AS s INNER JOIN Project AS p 
ON s.ServiceID = p.ServiceID
GROUP BY s.ServiceID, s.ServiceName
order by s.ServiceName
end

and the result is:
Kitchens (2)
Living Rooms (4)
------
but the services that have no projects are not retrieved .. i want them to be retrieved with 0 count like this:
Kitchens (2)
Living Rooms (4)
Bathrooms (0)

thanks in advance