Get Android post view by day

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

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;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results