Select Year(Posts.CreationDate), Count(*) As Posts From P...

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 
    Year(Posts.CreationDate), 
    Count(*) As Posts
From 
    Posts 
Where 
    PostTypeId = 1 And 
    Tags Like '%<ms-access%>%' And 
    Posts.CreationDate >= '2015-01-01'
Group By
    Year(Posts.CreationDate)

Enter Parameters

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