SELECT Tags, Count(*) as n_posts, YEAR(CreationDate) as y...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Game Development Meta

Q&A about the site for professional and independent game developers

SELECT Tags, 
  Count(*) as n_posts,   
  YEAR(CreationDate) as year_post, 
  MONTH(CreationDate) as month_post, 
  DAY(CreationDate) as day_post
FROM dbo.Posts 
Where Tags LIKE '%diffusers%'
AND CreationDate BETWEEN '2019/01/01' AND '2024/02/20'
group by YEAR(CreationDate),  MONTH(CreationDate), DAY(CreationDate), Tags;

Enter Parameters

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