0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software quality control experts, automation engineers, and software testers

SELECT 
        t.TagName,Count(*)
    FROM 
        Posts p
    JOIN PostTags pt on p.Id = pt.PostId
    JOIN Tags t on pt.TagId = t.Id
    WHERE
      p.CreationDate >= '01.01.2019 00:00:00' and
      (t.TagName = 'opencl'
      or t.TagName = 'cuda'
      or t.TagName = 'openacc'
      or t.TagName = 'openmp'
      or t.TagName = 'cuda'
      or t.TagName = 'accelerate-haskell'
      )
    GROUP BY t.TagName;

fork query

edited jul 3 20 anonymous

created feb 8 16 jon.doe21521