select null as 'Appointments', count(EventType) as 'Mobile Welcome', v.AHMDealer as 'Dealer Number', p.Name as 'Dealer Name'
from CustomerEvent ce with (nolock)
join Resource r with (nolock) on ce.resourceid=r.resourceid
join Vendor v with (nolock) on r.VendorId = v.VendorId
join Profile p with (nolock) on v.ProfileId=p.profileid
where EventType=8 and DateEvent between '2015-01-01 00:00:00.000' and '2015-01-31 00:00:00.000' 

group by v.AHMDealer, p.name

union 

select count(EventType) as 'Appointments', null as 'Mobile Welcome', v.AHMDealer as 'Dealer Number', p.Name as 'Name'
from CustomerEvent ce with (nolock)
join Resource r with (nolock) on ce.resourceid=r.resourceid
join Vendor v with (nolock) on r.VendorId = v.VendorId
join Profile p with (nolock) on v.ProfileId=p.profileid
where EventType=11 and DateEvent between '2015-01-01 00:00:00.000' and '2015-01-31 00:00:00.000' 

group by v.AHMDealer, p.name