select DATEADD(DAY, DATEDIFF(DAY, 0, creationdate), 0) da...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

select DATEADD(DAY, DATEDIFF(DAY, 0, creationdate), 0) date, 'Python (Data Science)' programming_language,
         sum(case when   tags like '%scikit-learn%'
                      or tags like '%pytorch%'
                      or tags like '%pyspark%' 
                      or tags like '%theano%'
                      or tags like '%numpy%'
                      or tags like '%scipy%'
                      or tags like '%pandas%' 
                      or tags like '%scrapy%'
                      or (tags like '%py%' and ( tags like '%keras%' 
                                              or tags like '%tensorflow%'
                                              or tags like '%machine-learning%'
                                              or tags like '%deep-learning%'
                                              or tags like '%h2o%'
                                              or tags like '%artificial-intelligence%'
                                               )
                          ) then 1 else 0 end
         ) question_count
  from posts
  where posttypeid = 1
  and creationdate < '2020-07-01'
  and creationdate >= '2010-01-01'
  group by DATEADD(DAY, DATEDIFF(DAY, 0, creationdate), 0)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results