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 Tags.TagName, 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 (
'deep-learning',
'machine-learning',
'pytorch',
'keras',
'google-cloud-ml',
'amazon-sagemaker',
'amazon-lex',
'amazon-rekognition',
'amazon-kendra',
'azure-machine-learning-studio',
'azure-machine-learning-service',
'azure-machine-learning-workbench',
'cuda',
'pycuda',
'cudf',
'nvidia',
'cudnn',
'nvidia-jetson',
'opencl',
'pyopencl',
'opencl-c',
'bots',
'chatbot',
'botframework',
'facebook-messenger-bot',
'facebook-chatbot',
'botkit',
'azure-bot-service',
'tensorflow',
'tensorflow2.0',
'tensorflow-datasets',
'tensorflow-serving',
'tensorflow-lite',
'tensorflow.js',
'tensorflow-estimator',
'tensorflow-gpu',
'tensorflow-probability',
'tensorflow-hub',
'tensorflow2.x',
'tensorflow-federated',
'tensorflowjs-converter',
'artificial-intellience',
'supervised-learning',
'unsupervised-learning',
'neural-network',
'opencv',
'opencv3.0',
'coreml',
'coremltools',
'gpgpu',
'data-mining',
'computer-vision',
'scikit-learn',
'classification',
'mlp',
'conv-neural-network',
'lstm',
'classification',
'cluster-analysis',
'roc',
'sentiment-analysis',
'feature-selection',
'weka',
'nlp',
'nltk',
'spacy',
'word2vec',
'stanford-nlp',
'object-detection',
'multilabel-classification',
'microsoft-machine-learning-server',
'gradient-descent',
'opencv4',
'backpropagation',
'feature-extraction',
'softmax',
'activation-function',
'sigmoid',
'logistic-regression',
'deconvolution',
'decision-tree',
'reinforcement-learning',
'vectorization',
'google-mlkit',
'firebase-mlkit',
'openai-gym',
'nearest-neighbor',
'random-forest',
'cross-entropy',
'svm',
'libsvm'
)

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

view current version

edited jan 19

created jan 19 Ben.Wilson