select c.CampID, c.Title, c.EMSubject, s.Sentdate, s.totalsent, s.totalopens, s.totalclicks,u.TotalUnsubscribed from statsEmailSummary s inner join Campaign c on s.Campid = c.CampID inner join ( select CampaignID, SUM(Unsubscribes) as TotalUnsubscribed from statsEmail where CampaignID = group by CampaignID ) u on s.CampID = u.CampaignID where s.totalsent > 10 and s.CampID = order by s.sentdate desc select * from statsEmail where CampaignID = and MonthYear between GETDATE()-360 and getdate() select click.TargetURL, COUNT(click_id) as TotalClicks from Campaign c inner join STAGE_AD_ASSET s on c.Asset_ID = s.Asset_ID inner join TRACK_AD_CLICKTHRU click on s.Asset_ID = click.Asset_ID where c.CampID = group by click.TargetURL order by TotalClicks desc Campaigns