0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select tb2.date, sum(tb2.ViewCount) from
(
  SELECT 

   CONVERT(date, tb.CreationDate) as 'date', tb.ViewCount

  FROM
  (

  SELECT CreationDate, ViewCount FROM Posts
    WHERE Tags like '%angularjs%'
    and CreationDate between '2016-01-01' and '2020-12-31'

  ) as tb
) as tb2
GROUP BY TB2.DATE
order by 1;

fork query

edited nov 19

created nov 19 Igor.Braga