Q&A for professional and enthusiast programmers
SET DATEFORMAT ymd; SELECT Tags.TagName, CONVERT(VARCHAR(7), Posts.CreationDate, 126) as month , COUNT(*) as tag_count FROM Posts JOIN PostTags ON PostTags.PostId = Posts.Id JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN ( 'google-cloud-firestore' , 'google-cloud-datastore' , 'google-cloud-memorystore' , 'google-cloud-sql' , 'google-cloud-bigtable' , 'google-cloud-spanner' , 'google-cloud-bigquery' , 'amazon-dynamodb' , 'amazon-redshift' , 'amazon-rds' , 'azure-sql-database' , 'azure-cosmosdb' , 'cloudant' ) AND Posts.CreationDate < DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0) GROUP BY Tags.TagName, CONVERT(VARCHAR(7), Posts.CreationDate, 126) ORDER BY month DESC, tag_count desc