ตามแท็กเฉพาะ ไม่จำเป็นต้องใช้ตารางทั้งหมด
s by specific tag.It is not neccessary to use all the tables.
 PostLinks:  Id [ number]  CreationDate [ time]  PostId [ number]  RelatedPostId [ number]  LinkTypeId [ number] 
WITH FirstQuestions AS (SELECT * FROM Posts AS Q WHERE Q.PostTypeId = 1 AND NOT EXISTS(SELECT * FROM Posts AS P WHERE P.OwnerUserId = Q.OwnerUserId AND P.PostTypeId = 1 AND P.CreationDate < Q.CreationDate)), UserQuestions AS (SELECT U.*, (CASE WHEN Q.Tags LIKE @Pattern THEN 1 ELSE 0 END) AS "isid" FROM Users AS U INNER JOIN FirstQuestions AS Q ON Q.OwnerUserId = U.Id) SELECT COUNT(*) AS "all", SUM(IsID) AS "id" FROM UserQuestions