Number of answers in each language

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT COUNT(*) AS 'Python total'
FROM Posts A
WHERE
  A.PostTypeId = 2 AND (
  A.Body LIKE '<h1>Python,%'
  OR A.Body LIKE '<h2>Python,'
  OR A.Body LIKE '<h1>Python %'
  OR A.Body LIKE '<h2>Python %'
  )

SELECT COUNT(*) AS 'JavaScript total'
FROM Posts A
WHERE
  A.PostTypeId = 2 AND (
  A.Body LIKE '<h1>JavaScript,%'
  OR A.Body LIKE '<h2>JavaScript,'
  OR A.Body LIKE '<h1>JavaScript %'
  OR A.Body LIKE '<h2>JavaScript %'
  )

SELECT COUNT(*) AS 'C total'
FROM Posts A
WHERE
  A.PostTypeId = 2 AND (
  A.Body LIKE '<h1>C,%'
  OR A.Body LIKE '<h2>C,'
  OR A.Body LIKE '<h1>C %'
  OR A.Body LIKE '<h2>C %'
  )

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results