Percentage of GraphQL related questions over time

1

Please login or register to vote for this query.

(click on this box to dismiss)

See the relative popularity of GraphQL over time

Blender Meta

Q&A about the site for people who use Blender to create 3D graphics, animations, or games

SELECT
  G.DateMonth,
  NumberOfGraphQLQuestions,
  TotalNumberOfQuestions,
  (CAST(NumberOfGraphQLQuestions AS FLOAT) / CAST(TotalNumberOfQuestions AS FLOAT) * 100.0) as 'Percent'
FROM (
  SELECT
    FORMAT(CreationDate, 'yyyy-MM') AS DateMonth,
    COUNT(*) AS NumberOfGraphQLQuestions
  FROM
    Posts
  WHERE
    PostTypeId = 1
    AND CreationDate > '2015-01-01'
    AND (LOWER(TAGS) LIKE '%graphql%'
    OR LOWER(TITLE) LIKE '%graphql%')
  GROUP BY
    FORMAT(CreationDate, 'yyyy-MM')
) AS G
JOIN (
  SELECT
    FORMAT(CreationDate, 'yyyy-MM') AS DateMonth,
    COUNT(*) AS TotalNumberOfQuestions
  FROM
    Posts
  WHERE
    PostTypeId = 1
    AND CreationDate > '2015-01-01'
  GROUP BY
    FORMAT(CreationDate, 'yyyy-MM')
) AS T
ON
  G.DateMonth = T.DateMonth
ORDER BY
  DateMonth

Enter Parameters

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