0

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 
       num.TagName as Tag,
       prev_rate.prev_rate as prev_rate,
       cur_rate.cur_rate as cur_rate,
       ((cur_rate.cur_rate - prev_rate.prev_rate) / prev_rate.prev_rate) as chg

from

(select count(PostId) as cur_rate, TagName
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate > DATEADD(DAY, -91, GETDATE())  
and Posts.CreationDate < GETDATE()
and Tags.TagName IN (

'alexa',
'alexa-skills-kit',
'alexa-skill',
'alexa-voice-service',
'amazon-kinesis',
'amazon-kinesis-firehose',
'amazon-sagemaker',
'amazon-lex',
'amazon-rekognition',
'amazon-kendra',
'amazon-cloudformation',
'aws-lambda',
'aws-serverless',
'amazon-redshift',
'amazon-redshift-spectrum',
'Rocm',
'opencl',
'pyopencl',
'opencl-c',
'apache-spark',
'pyspark',
'apache-spark-sql',
'cassandra',
'cql',
'hadoop',
'hadoop2',
'hadoop3',
'hive',
'hiveql',
'apache-kafka',
'kafka-consumer-api',
'apache-kafka',
'apache-kafka-streams',
'spring-kafka',
'apache-kafka-connect',
'kafka-producer-api',
'coreml',
'coremltools',
'siri',
'sirikit',
'sirishortcuts',
'c3ai-datalake',
'c3ai-datalake',
'coinbase-api',
'confluent-platform',
'confluent-schema-registry',
'couchbase',
'couchbase-lite',
'spring-data-couchbase',
'couchdb',
'datastax',
'datastax-enterprise',
'datastax-java-driver',
'elasticsearch',
'elastic-stack',
'facebook-messenger-bot',
'facebook-chatbot',
'botkit',
'pytorch',
'google-bigquery',
'bigquery-standard-sql',
'firebase-mlkit',
'google-cloud-ml',
'google-colaboratory',
'google-mlkit',
'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',
'google-assistant-sdk',
'google-home',
'terraform',
'terraform-provider-aws',
'terraform-provider-azure',
'terraform-provider-gcp',
'terraform0.12+',
'terraform-template-file',
'terraform-provider-openstack',
'terraform-provider-kubernetes',
'terraform-cloud',
'terraform-modules',
'terraform0.11',
'terraform-enterprise',
'terraform-remote-state',
'terraform-provider-cloudflare',
'terraform-provider-github',
'terraform-aws-modules',
'hyperledger',
'hyperledger-fabric',
'hyperledger-composer',
'hyperledger-fabric-ca',
'hyperledger-chaincode',
'hyperledger-sawtooth',
'hyperledger-fabric-sdk-js',
'jfrog-cli',
'artifactory',
'materialize',
'azure-machine-learning-studio',
'azure-machine-learning-service',
'azure-machine-learning-workbench',
'azure-cosmosdb',
'azure-functions',
'azure-functions-runtime',
'azure-functions-core-tools',
'azure-bot-service',
'cortana',
'cortana-intelligence',
'cortana-skills-kit',
'cortana-invoke',
'microsoft-machine-learning-server',
'visual-studio-code',
'xamarin',
'botframework',
'mongodb',
'mongodb-query',
'spring-data-mongodb',
'mongodb-.net-driver',
'mongodb-java',
'mongodb-atlas',
'mongodb-php',
'bitcoin',
'blockchain',
'bots ',
'chatbot',
'ethereum',
'solidity',
'truffle',
'jenkins',
'cuda',
'pycuda',
'cudf',
'nvidia',
'cudnn',
'nvidia-jetson',
'oracle',
'oracle11g',
'oracle10g',
'oracle-sqldeveloper',
'oracle-apex',
'oracle12c',
'braintree',
'paypal',
'paypal-sandbox',
'paypal-ipn',
'paypal-rest-sdk',
'paypal-adaptive-payments',
'paypal-subscriptions',
'paypal-mobile-sdk',
'redis',
'stackexchange.redis',
'spring-data-redis',
'node-redis',
'redis-cluster',
'snowflake-cloud-data-platform',
'snowflake-schema',
'snowflake-task',
'snowflake-pipe',
'stripe-payments',
'teradata',
'teradata-sql-assistant',
'teradata-covalent',
'teradata-aster',
'timescaledb',
'keras',
'openai-gym',
'scikit-learn',
'theano',
'artificial-intelligence',
'deep-learning',
'machine-learning',
'artificial-intellience',
'supervised-learning',
'unsupervised-learning',
'neural-network',
'opencv',
'opencv3.0',
'gpgpu',
'data-mining',
'computer-vision',
'classification',
'mlp',
'conv-neural-network',
'lstm',
'classification',
'cluster-analysis',
'sentiment-analysis',
'feature-selection',
'weka',
'nlp',
'natural-languate-processing',
'recurrent-neural-network',
'nltk',
'spacy',
'word2vec',
'stanford-nlp',
'object-detection',
'multilabel-classification',
'gradient-descent',
'opencv4',
'backpropagation',
'feature-extraction',
'softmax',
'activation-function',
'sigmoid',
'logistic-regression',
'deconvolution',
'decision-tree',
'reinforcement-learning',
'vectorization',
'nearest-neighbor',
'random-forest',
'cross-entropy',
'svm',
'libsvm',
'classification'
  )
group by TagName) as cur_rate

INNER JOIN 

(select count(PostId) as prev_rate, TagName
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate > DATEADD(DAY, -457, GETDATE())  
and Posts.CreationDate < DATEADD(DAY, -366, GETDATE()) 
and Tags.TagName IN (

'alexa',
'alexa-skills-kit',
'alexa-skill',
'alexa-voice-service',
'amazon-kinesis',
'amazon-kinesis-firehose',
'amazon-sagemaker',
'amazon-lex',
'amazon-rekognition',
'amazon-kendra',
'amazon-cloudformation',
'aws-lambda',
'aws-serverless',
'amazon-redshift',
'amazon-redshift-spectrum',
'Rocm',
'opencl',
'pyopencl',
'opencl-c',
'apache-spark',
'pyspark',
'apache-spark-sql',
'cassandra',
'cql',
'hadoop',
'hadoop2',
'hadoop3',
'hive',
'hiveql',
'apache-kafka',
'kafka-consumer-api',
'apache-kafka',
'apache-kafka-streams',
'spring-kafka',
'apache-kafka-connect',
'kafka-producer-api',
'coreml',
'coremltools',
'siri',
'sirikit',
'sirishortcuts',
'c3ai-datalake',
'c3ai-datalake',
'coinbase-api',
'confluent-platform',
'confluent-schema-registry',
'couchbase',
'couchbase-lite',
'spring-data-couchbase',
'couchdb',
'datastax',
'datastax-enterprise',
'datastax-java-driver',
'elasticsearch',
'elastic-stack',
'facebook-messenger-bot',
'facebook-chatbot',
'botkit',
'pytorch',
'google-bigquery',
'bigquery-standard-sql',
'firebase-mlkit',
'google-cloud-ml',
'google-colaboratory',
'google-mlkit',
'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',
'google-assistant-sdk',
'google-home',
'terraform',
'terraform-provider-aws',
'terraform-provider-azure',
'terraform-provider-gcp',
'terraform0.12+',
'terraform-template-file',
'terraform-provider-openstack',
'terraform-provider-kubernetes',
'terraform-cloud',
'terraform-modules',
'terraform0.11',
'terraform-enterprise',
'terraform-remote-state',
'terraform-provider-cloudflare',
'terraform-provider-github',
'terraform-aws-modules',
'hyperledger',
'hyperledger-fabric',
'hyperledger-composer',
'hyperledger-fabric-ca',
'hyperledger-chaincode',
'hyperledger-sawtooth',
'hyperledger-fabric-sdk-js',
'jfrog-cli',
'artifactory',
'materialize',
'azure-machine-learning-studio',
'azure-machine-learning-service',
'azure-machine-learning-workbench',
'azure-cosmosdb',
'azure-functions',
'azure-functions-runtime',
'azure-functions-core-tools',
'azure-bot-service',
'cortana',
'cortana-intelligence',
'cortana-skills-kit',
'cortana-invoke',
'microsoft-machine-learning-server',
'visual-studio-code',
'xamarin',
'botframework',
'mongodb',
'mongodb-query',
'spring-data-mongodb',
'mongodb-.net-driver',
'mongodb-java',
'mongodb-atlas',
'mongodb-php',
'bitcoin',
'blockchain',
'bots ',
'chatbot',
'ethereum',
'solidity',
'truffle',
'jenkins',
'cuda',
'pycuda',
'cudf',
'nvidia',
'cudnn',
'nvidia-jetson',
'oracle',
'oracle11g',
'oracle10g',
'oracle-sqldeveloper',
'oracle-apex',
'oracle12c',
'braintree',
'paypal',
'paypal-sandbox',
'paypal-ipn',
'paypal-rest-sdk',
'paypal-adaptive-payments',
'paypal-subscriptions',
'paypal-mobile-sdk',
'redis',
'stackexchange.redis',
'spring-data-redis',
'node-redis',
'redis-cluster',
'snowflake-cloud-data-platform',
'snowflake-schema',
'snowflake-task',
'snowflake-pipe',
'stripe-payments',
'teradata',
'teradata-sql-assistant',
'teradata-covalent',
'teradata-aster',
'timescaledb',
'keras',
'openai-gym',
'scikit-learn',
'theano',
'artificial-intelligence',
'deep-learning',
'machine-learning',
'artificial-intellience',
'supervised-learning',
'unsupervised-learning',
'neural-network',
'opencv',
'opencv3.0',
'gpgpu',
'data-mining',
'computer-vision',
'classification',
'mlp',
'conv-neural-network',
'lstm',
'classification',
'cluster-analysis',
'sentiment-analysis',
'feature-selection',
'weka',
'nlp',
'natural-languate-processing',
'recurrent-neural-network',
'nltk',
'spacy',
'word2vec',
'stanford-nlp',
'object-detection',
'multilabel-classification',
'gradient-descent',
'opencv4',
'backpropagation',
'feature-extraction',
'softmax',
'activation-function',
'sigmoid',
'logistic-regression',
'deconvolution',
'decision-tree',
'reinforcement-learning',
'vectorization',
'nearest-neighbor',
'random-forest',
'cross-entropy',
'svm',
'libsvm',
'classification'
  )
group by TagName) as prev_rate

ON cur_rate.TagName = prev_rate.TagName


INNER JOIN

(select count(PostId) as Num, TagName
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate > DATEADD(DAY, -180, GETDATE())  
and Tags.TagName IN (

'alexa',
'alexa-skills-kit',
'alexa-skill',
'alexa-voice-service',
'amazon-kinesis',
'amazon-kinesis-firehose',
'amazon-sagemaker',
'amazon-lex',
'amazon-rekognition',
'amazon-kendra',
'amazon-cloudformation',
'aws-lambda',
'aws-serverless',
'amazon-redshift',
'amazon-redshift-spectrum',
'Rocm',
'opencl',
'pyopencl',
'opencl-c',
'apache-spark',
'pyspark',
'apache-spark-sql',
'cassandra',
'cql',
'hadoop',
'hadoop2',
'hadoop3',
'hive',
'hiveql',
'apache-kafka',
'kafka-consumer-api',
'apache-kafka',
'apache-kafka-streams',
'spring-kafka',
'apache-kafka-connect',
'kafka-producer-api',
'coreml',
'coremltools',
'siri',
'sirikit',
'sirishortcuts',
'c3ai-datalake',
'c3ai-datalake',
'coinbase-api',
'confluent-platform',
'confluent-schema-registry',
'couchbase',
'couchbase-lite',
'spring-data-couchbase',
'couchdb',
'datastax',
'datastax-enterprise',
'datastax-java-driver',
'elasticsearch',
'elastic-stack',
'facebook-messenger-bot',
'facebook-chatbot',
'botkit',
'pytorch',
'google-bigquery',
'bigquery-standard-sql',
'firebase-mlkit',
'google-cloud-ml',
'google-colaboratory',
'google-mlkit',
'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',
'google-assistant-sdk',
'google-home',
'terraform',
'terraform-provider-aws',
'terraform-provider-azure',
'terraform-provider-gcp',
'terraform0.12+',
'terraform-template-file',
'terraform-provider-openstack',
'terraform-provider-kubernetes',
'terraform-cloud',
'terraform-modules',
'terraform0.11',
'terraform-enterprise',
'terraform-remote-state',
'terraform-provider-cloudflare',
'terraform-provider-github',
'terraform-aws-modules',
'hyperledger',
'hyperledger-fabric',
'hyperledger-composer',
'hyperledger-fabric-ca',
'hyperledger-chaincode',
'hyperledger-sawtooth',
'hyperledger-fabric-sdk-js',
'jfrog-cli',
'artifactory',
'materialize',
'azure-machine-learning-studio',
'azure-machine-learning-service',
'azure-machine-learning-workbench',
'azure-cosmosdb',
'azure-functions',
'azure-functions-runtime',
'azure-functions-core-tools',
'azure-bot-service',
'cortana',
'cortana-intelligence',
'cortana-skills-kit',
'cortana-invoke',
'microsoft-machine-learning-server',
'visual-studio-code',
'xamarin',
'botframework',
'mongodb',
'mongodb-query',
'spring-data-mongodb',
'mongodb-.net-driver',
'mongodb-java',
'mongodb-atlas',
'mongodb-php',
'bitcoin',
'blockchain',
'bots ',
'chatbot',
'ethereum',
'solidity',
'truffle',
'jenkins',
'cuda',
'pycuda',
'cudf',
'nvidia',
'cudnn',
'nvidia-jetson',
'oracle',
'oracle11g',
'oracle10g',
'oracle-sqldeveloper',
'oracle-apex',
'oracle12c',
'braintree',
'paypal',
'paypal-sandbox',
'paypal-ipn',
'paypal-rest-sdk',
'paypal-adaptive-payments',
'paypal-subscriptions',
'paypal-mobile-sdk',
'redis',
'stackexchange.redis',
'spring-data-redis',
'node-redis',
'redis-cluster',
'snowflake-cloud-data-platform',
'snowflake-schema',
'snowflake-task',
'snowflake-pipe',
'stripe-payments',
'teradata',
'teradata-sql-assistant',
'teradata-covalent',
'teradata-aster',
'timescaledb',
'keras',
'openai-gym',
'scikit-learn',
'theano',
'artificial-intelligence',
'deep-learning',
'machine-learning',
'artificial-intellience',
'supervised-learning',
'unsupervised-learning',
'neural-network',
'opencv',
'opencv3.0',
'gpgpu',
'data-mining',
'computer-vision',
'classification',
'mlp',
'conv-neural-network',
'lstm',
'classification',
'cluster-analysis',
'sentiment-analysis',
'feature-selection',
'weka',
'nlp',
'natural-languate-processing',
'recurrent-neural-network',
'nltk',
'spacy',
'word2vec',
'stanford-nlp',
'object-detection',
'multilabel-classification',
'gradient-descent',
'opencv4',
'backpropagation',
'feature-extraction',
'softmax',
'activation-function',
'sigmoid',
'logistic-regression',
'deconvolution',
'decision-tree',
'reinforcement-learning',
'vectorization',
'nearest-neighbor',
'random-forest',
'cross-entropy',
'svm',
'libsvm',
'classification'
  )
group by TagName
having count(PostId) > 20)
as num ON cur_rate.TagName = num.TagName


order by chg desc

fork query

edited jan 20

created jan 19 Ben.Wilson