ผู้ใช้ใหม่ถาม ไม่จำเป็นต้องใช้ตารางทั้งหมด
s new users ask.It is not neccessary to use all the tables.
 PostHistory:  Id [ number]  PostHistoryTypeId [ number]  PostId [ number]  RevisionGUID [ other]  CreationDate [ time]  UserId [ number]  UserDisplayName [ text]  Comment [ text]  Text [ text]  ContentLicense [ text] 
SELECT t.Id, t.TagName, COUNT(*) AS "Number questions" FROM (SELECT DISTINCT pq.Id, pt.TagId FROM Users AS u JOIN Posts AS p ON p.OwnerUserId = u.Id JOIN Posts AS pq ON pq.Id = p.ParentId JOIN PostTags AS pt ON pt.PostId = pq.Id WHERE pq.ViewCount > 0 AND (pq.CreationDate BETWEEN '2012-01-01' AND '2012-10-01') AND u.CreationDate BETWEEN '2011-09-01' AND '2012-10-01') AS ut JOIN Tags AS t ON t.Id = ut.TagId GROUP BY t.Id, t.TagName HAVING COUNT(*) > 100 ORDER BY 3 DESC