SELECT '2019-02-01' as date, COUNT(DISTINCT(Posts.OwnerUs...

0

Please login or register to vote for this query.

(click on this box to dismiss)

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

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

SELECT '2019-02-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2019-02-01' UNION
SELECT '2019-03-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2019-03-01' UNION
SELECT '2019-04-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2019-04-01' UNION
SELECT '2019-05-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2019-05-01' UNION
SELECT '2019-06-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2019-06-01' UNION
SELECT '2019-07-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2019-07-01' UNION
SELECT '2019-08-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2019-08-01' UNION
SELECT '2019-09-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2019-09-01' UNION
SELECT '2019-10-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2019-10-01' UNION
SELECT '2019-11-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2019-11-01' UNION
SELECT '2019-12-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2019-12-01' UNION
SELECT '2020-01-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2020-01-01' UNION
SELECT '2020-02-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2020-02-01' UNION
SELECT '2020-03-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2020-03-01' UNION
SELECT '2020-04-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2020-04-01' UNION
SELECT '2020-05-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2020-05-01' UNION
SELECT '2020-06-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2020-06-01' UNION
SELECT '2020-07-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2020-07-01' UNION
SELECT '2020-08-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2020-08-01' UNION
SELECT '2020-09-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2020-09-01' UNION
SELECT '2020-10-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2020-10-01' UNION
SELECT '2020-11-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2020-11-01' UNION
SELECT '2020-12-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2020-12-01' UNION
SELECT '2021-01-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2021-01-01' UNION
SELECT '2021-02-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2021-02-01'

Enter Parameters

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