IBM Cloud Tags ตามปี ไม่จำเป็นต้องใช้ตารางทั้งหมด
IBM Cloud Tags by year.It is not neccessary to use all the tables.
 PostHistoryTypes:  Id [ number]  Name [ text] 
WITH tag_year AS (SELECT TIME_TO_STR(Posts.CreationDate, '%B') + ' ' + CAST(TIME_TO_STR(Posts.CreationDate, '%Y') AS TEXT) AS year, Tags.TagName AS cloud, Posts.Id AS postid FROM PostTags JOIN Tags ON PostTags.TagId = Tags.Id JOIN Posts ON PostTags.PostId = Posts.Id JOIN PostTypes ON Posts.PostTypeId = PostTypes.Id WHERE PostTypes.Name = 'Question' AND YEAR(Posts.CreationDate) >= 2015 AND (Tags.TagName LIKE '%bluemix%' OR Tags.TagName LIKE '%softlayer%' OR Tags.TagName LIKE '%ibm-cloud%' OR Tags.TagName LIKE '%ibm-watson%')) SELECT year, cloud, COUNT(DISTINCT PostId) AS questions FROM tag_year GROUP BY year, cloud