Number of posts with JS Testing Frameworks tags since 2018

0

Please login or register to vote for this query.

(click on this box to dismiss)

Monero Meta

Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero

-- How many questions per month for configuration management frameworks?

select *, count(*) AS post_count from
(
  select 
    t.TagName 
  from (
    select p.Id, p.CreationDate from Posts p 
    join PostTags pt on pt.PostId = p.Id
    join Tags t on t.Id = pt.TagId
    ) pp
  join PostTags pt on pt.PostId = pp.Id
  join Tags t on t.Id = pt.TagId
  
  where
    (
    (
      lower(t.TagName) LIKE '%qunit%' OR
      lower(t.TagName) LIKE '%mocha%' OR 
      lower(t.TagName) LIKE '%jest%' OR    
      lower(t.TagName) LIKE '%jasmine%' OR
      lower(t.TagName) LIKE '%funcunit%' OR
      lower(t.TagName) LIKE '%puppeteer%' OR
      lower(t.TagName) LIKE '%cypress%'
    ) AND
    (
      lower(t.TagName) NOT LIKE 'jester' AND
      lower(t.TagName) NOT LIKE 'tomochain'
    )
    ) 
    AND
    pp.CreationDate > '1/1/2018'
    
    
) as X
group by TagName
order by count(*) desc

Enter Parameters

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