Indicators histogram

gistfile1.txt

select ind.NewsHeadlinesIndicatorId, ind.Title, ii.cnt from NewsHeadlinesIndicator ind 
join (
select NewsHeadlinesindicatorId, count(*) as cnt from (
SELECT [NewsHeadlinesIndicatorId]
      ,[FundId]
      ,[EventDTM]
      ,[NewsHeadlinesZoneId]
      ,[Trend]
      ,[OccurrencesTotal]
      ,[OccurrencesChecked]
      ,[PeriodLength]
      ,[Weight]
      ,[Gain]
      ,RANK() over (partition by FundId order by Weight desc) as rn
  FROM [dbo].[NewsHeadlines]
  ) i where i.rn = 1
  group by NewsHeadlinesIndicatorId 
  ) ii
  on ind.NewsHeadlinesIndicatorId = ii.NewsHeadlinesIndicatorId
  
  order by 3 desc