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)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

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 '%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 >= '2020-06-01'
group by DATEADD(DAY, DATEDIFF(DAY, 0, creationdate), 0)
order by date

Enter Parameters

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