0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

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 '%copilot%'
AND CreationDate BETWEEN '2019/01/01' AND '2024/02/20'
group by YEAR(CreationDate),  MONTH(CreationDate), DAY(CreationDate), Tags;

fork query

edited feb 21

created feb 20 anonymous