คำถามที่ติดแท็ก vba โดยมี/ไม่มีตัวแปร vba ไม่จำเป็นต้องใช้ตารางทั้งหมด
Questions tagged vba, with/without vba variants.It is not neccessary to use all the tables.
 Comments:  Id [ number]  PostId [ number]  Score [ number]  Text [ text]  CreationDate [ time]  UserDisplayName [ text]  UserId [ number]  ContentLicense [ text] 
SELECT COUNT(Posts.Id) FROM Posts INNER JOIN (SELECT DISTINCT PostId FROM PostTags WHERE TagId = (SELECT Id FROM Tags WHERE TagName = 'vba')) AS t1 ON Posts.Id = t1.PostId WHERE Posts.PostTypeId = 1 UNION ALL SELECT COUNT(Posts.Id) FROM Posts INNER JOIN (SELECT DISTINCT PostId FROM PostTags WHERE TagId = (SELECT Id FROM Tags WHERE TagName = 'vba')) AS t1 ON Posts.Id = t1.PostId LEFT JOIN (SELECT DISTINCT PostId FROM PostTags INNER JOIN (SELECT Id FROM Tags WHERE TagName LIKE '%-vba') AS t2 ON PostTags.TagId = t2.Id) AS t3 ON Posts.Id = t3.PostId WHERE Posts.PostTypeId = 1 AND t3.PostId IS NULL