SELECT CASE WHEN Tags like 'aws%' THEN 'Amazon Web Servic...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

SELECT 
    CASE
      WHEN Tags like 'aws%' THEN 'Amazon Web Services'
      WHEN Tags like 'amazon-%' THEN 'Amazon Web Services'
      WHEN Tags like 'google-cloud%' THEN 'Google Cloud Platform'
      WHEN Tags like 'firebase%' THEN 'Google Cloud Platform'
      WHEN Tags like 'google-compute-%' OR Tags like 'google-container-%' THEN 'Google Cloud Platform'
      WHEN Tags like '%app-engine%' THEN 'Google Cloud Platform'
      WHEN Tags like 'google-bigquery%' THEN 'Google Cloud Platform'
      WHEN Tags like '%bluemix%' THEN 'IBM Cloud'
      WHEN Tags like '%softlayer%' THEN 'IBM Cloud'
      WHEN Tags like 'ibm-cloud%' THEN 'IBM Cloud'
      WHEN Tags like 'ibm-watson%' THEN 'IBM Cloud'
      WHEN Tags like '%azure%' THEN 'Microsoft Azure'
      ELSE 'NON'
    END as cloud,
      DATEPART(yyyy, CreationDate),
      DATEPART(mm, CreationDate),
COUNT(*) as QuestionCount,
    COUNT(DISTINCT OwnerUserId) as Users
  FROM Posts 
  WHERE 
  
   (
      Tags like 'aws-%'
      OR Tags like 'amazon-%'
      OR Tags like 'google-cloud%'
      OR Tags like 'firebase%'
      OR Tags like 'google-compute-%' OR tags like 'google-container-%'
      OR Tags like '%app-engine%'
      OR Tags like 'google-bigquery%'
      OR Tags like '%bluemix%'
      OR Tags like '%softlayer%'
      OR Tags like 'ibm-cloud%'
      OR Tags like 'ibm-watson%'
      OR Tags like 'azure%'
      )
      
      
  GROUP BY Tags,DATEPART(yyyy, CreationDate),
      DATEPART(mm, CreationDate);

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results