2017 JS Framework total Posts per tag Angular, React, Vue, Ember and Polymer

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフローMeta

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

Declare @startDate AS Date = '12/31/2018'
Declare @endDate AS Date = '04/22/2019'

SELECT sum(case
    WHEN tags LIKE '%angular%'
        AND tags NOT LIKE '%angularjs%'
        AND CreationDate
    BETWEEN @startDate
        AND @endDate THEN
    1
    ELSE 0 end) AS angular, sum(case
    WHEN tags LIKE '%reactjs%'
        AND CreationDate
    BETWEEN @startDate
        AND @endDate THEN
    1
    ELSE 0 end) AS reactjs, sum(case
    WHEN tags LIKE '%ember.js%'
        AND CreationDate
    BETWEEN @startDate
        AND @endDate THEN
    1
    ELSE 0 end) AS ember, sum(case
    WHEN tags LIKE '%vue.js%'
        AND CreationDate
    BETWEEN @startDate
        AND @endDate THEN
    1
    ELSE 0 end) AS vuejs, sum(case
    WHEN tags LIKE '%polymer%'
        AND CreationDate
    BETWEEN @startDate
        AND @endDate THEN
    1
    ELSE 0 end) AS polymer
FROM posts
WHERE CreationDate
    BETWEEN @startDate
        AND @endDate

Enter Parameters

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