title

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

select year(creationdate) as Year,month(creationdate) as Month,
case when (Tags like '%python%' and Tags not like '%javascript%') then 'python'
     when (Tags like '%javascript%' and Tags not like '%python%') then 'javascript'
     else 'unkown' end Tags,Count(*) as Amount from Posts 
where ((Tags like '%python%' and Tags not like '%javascript%')
or (Tags like '%javascript%' and Tags not like '%python%'))
and year(creationdate)=2019 and month(creationdate) in (1,2)
group by year(creationdate),month(creationdate),
case when (Tags like '%python%' and Tags not like '%javascript%') then 'python'
     when (Tags like '%javascript%' and Tags not like '%python%') then 'javascript'
     else 'unkown' end;

Enter Parameters

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