1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for active researchers, academics and students of physics

SELECT 'Cloud' as name, CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') as date, COUNT(DISTINCT(Votes.id)) as vote_count , Count(DISTINCT(Posts.id)) as post_count, COUNT(DISTINCT(Posts.OwnerUserId)) as user_count
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 (
'aws-lambda',
'aws-sdk',
'aws-cli',
'aws-api-gateway',
'aws-glue',
'aws-amplify',
'terraform-provider-aws',
'aws-cognito',
'aws-iot',
'aws-code-deploy',
'aws-serverless',
'aws-codepipeline',
'aws-codebuild',
'aws-fargate',
'aws-opsworks',
'amazon-web-services',
'amazon-dynamodb',
'amazon-dynamodb-streams',
'amazon-ec2',
'amazon-rds',
'amazon-rds-aurora',
'amazon-s3',
'amazon-vpc',
'amazon-ecs',
'amazon-elastic-beanstalk',
'amazon-vpc',
'amazon-elastic-beanstalk',
'azure',
'azure-devops',
'azure-active-directory',
'azure-functions',
'azure-sql-database',
'azure-web-sites',
'azure-storage',
'azure-cosmosdb',
'azure-databricks',
'heroku',
'heroku-api',
'google-cloud-platform',
'google-cloud-platform',
'google-cloud-firestore',
'google-cloud-functions',
'google-cloud-storage',
'google-cloud-messaging',
'google-cloud-datastore',
'google-cloud-dataflow',
'google-cloud-sql',
'google-cloud-endpoints',
'google-cloud-pubsub',
'google-cloud-dataproc',
'google-cloud-ml',
'google-cloud-vision',
'google-cloud-stackdriver',
'google-cloud-build',
'google-cloud-run',
'google-cloud-composer',
'google-cloud-speech',
'google-cloud-datalab',
'google-cloud-bigtable',
'google-cloud-spanner',
'google-cloud-sdk',
'google-cloud-automl',
'google-cloud-iam',
'google-cloud-shell',
'google-cloud-logging',
'google-cloud-print',
'google-cloud-dns',
'google-cloud-ml-engine',
'google-cloud-dataprep',
'google-cloud-endpoints-v2',
'google-cloud-python',
'google-cloud-data-fusion',
'google-cloud-iot',
'google-cloud-console',
'google-cloud-networking',
'digital-ocean'
)

GROUP BY YEAR(Votes.CreationDate), MONTH(Votes.CreationDate)
ORDER BY YEAR(Votes.CreationDate), MONTH(Votes.CreationDate)

view current version

edited jan 19

created jan 19 Ben.Wilson