แท็กใดที่นำผู้ใช้มาที่ไซต์?. ข้อมูลนี้จะช่วยระบุสถิติบางประการว่าแท็กใดที่นำผู้ใช้ไปยังไซต์ และแท็กยังคงอยู่นานเท่าใด ไม่จำเป็นต้องใช้ตารางทั้งหมด
What tag brought a user to the site?. This will figure out some statistics as to what tags bring users to a site, and how long they stick around.It is not neccessary to use all the tables.
 ReviewTaskTypes:  Id [ number]  Name [ text]  Description [ text] 
WITH FirstPosts AS (SELECT OwnerUserId AS SEUser, MIN(Id) AS Post FROM Posts GROUP BY OwnerUserId), UserQuestionCount AS (SELECT COUNT(Id) AS PostCount, OwnerUserId AS Id FROM Posts GROUP BY OwnerUserId) SELECT t.TagName, COUNT(Tags) AS Users, PostsPerUser = 1.0 * SUM(UserQuestionCount.PostCount) / COUNT(Tags), TotalPosts = 1.0 * SUM(UserQuestionCount.PostCount) FROM FirstPosts INNER JOIN Users ON FirstPosts.SEUser = Users.Id INNER JOIN Posts ON FirstPosts.Post = Posts.Id INNER JOIN PostTags AS pt ON Posts.Id = pt.PostId INNER JOIN Tags AS t ON pt.TagId = t.Id INNER JOIN UserQuestionCount ON Users.Id = UserQuestionCount.Id WHERE UserQuestionCount.PostCount > 1 GROUP BY t.TagName HAVING COUNT(Tags) > 0 ORDER BY Users DESC LIMIT 100