select distinct Tags.TagName, count(distinct Users.Id) as...

0

Please login or register to vote for this query.

(click on this box to dismiss)

3D Printing Meta

Q&A for 3D printing enthusiasts

select distinct
  Tags.TagName,
  count(distinct Users.Id) as askers
  -- Users.WebsiteUrl
  from Users
  JOIN Posts on Users.Id = Posts.OwnerUserId
  JOIN PostTags on Posts.ParentId = PostTags.PostId
  -- JOIN PostTags on Posts.Id = PostTags.PostId
  JOIN Tags on PostTags.TagId = Tags.Id
  where
  Posts.PostTypeId = 2
  AND
  Tags.TagName IN ( 'app-engine-flexible',
      'appengine-gradle-plugin',
      'gae-datastore',
      'gcloud',
      'gcloud-intellij',
      'gcloud-java',
      'gcloud-node',
      'gcloud-python',
      'gcsfuse',
      'gcutil',
      'google-app-engine',
      'google-bigquery',
      'google-cloud-bigtable',
      'google-cloud-dataflow',
      'google-cloud-datalab',
      'google-cloud-dataprep',
      'google-cloud-dataproc',
      'google-cloud-datastore',
      'google-cloud-dns',
      'google-cloud-dotnet',
      'google-cloud-eclipse',
      'google-cloud-endpoints',
      'google-cloud-intellij',
      'google-cloud-logging',
      'google-cloud-monitoring',
      'google-cloud-platform',
      'google-cloud-powershell',
      'google-cloud-pubsub',
      'google-cloud-sdk',
      'google-cloud-source-repos',
      'google-cloud-spanner',
      'google-cloud-sql',
      'google-cloud-storage',
      'google-cloud-trace',
      'google-cloud-visualstudio',
      'google-compute-engine',
      'google-container-engine',
      'google-container-os',
      'google-container-registry',
      'google-hadoop',
      'google-plugin-eclipse',
      'google-prediction',
      'google-stackdriver',
      'google-translate',
      'gsutil',
      'kubernetes',
      'stackdriver')
  and Posts.CreationDate > '2018-01-01'
  and WebsiteUrl like '%linkedin%'
  group by Tags.TagName

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results