gistfile1.txt

set transaction isolation level read uncommitted 

select 
	c.[Id], 
	c.[Name], 
	c.[SentOn], 
	count(s.Id) as sent, 
	sum(s.[Bounced]) as bounced,
	sum(s.[Complained]) as complained,
	sum(s.[Opened]) as opened,
        (select count(1) from [Email_Sent] s on c.Id = s.CampaignId inner join [Email_Clicked] ec on ec.[EmailId] = s.[Id]) as clicks
from [EmailCampaign] c
left join [Email_Sent] s on c.Id = s.CampaignId
group by 
	c.[Id], 
	c.[Name], 
	c.[SentOn]
order by 
	[SentOn] desc