ฉันลบแท็กการเข้าถึงไปแล้วกี่ครั้งแล้ว? ไม่จำเป็นต้องใช้ตารางทั้งหมด
How many access tag removals have I done?.It is not neccessary to use all the tables.
 SuggestedEdits:  Id [ number]  PostId [ number]  CreationDate [ time]  ApprovalDate [ time]  RejectionDate [ time]  OwnerUserId [ number]  Comment [ text]  Text [ text]  Title [ text]  Tags [ text]  RevisionGUID [ other] 
SELECT COUNT(*) FROM PostHistory AS po INNER JOIN PostHistory AS pe ON po.PostId = pe.PostId WHERE po.PostHistoryTypeId = 3 AND pe.PostHistoryTypeId = 6 AND po.Text LIKE '%<access>%' AND NOT pe.Text LIKE '%<access%>' AND pe.CreationDate > '2018-05-01' AND pe.CreationDate < '2018-06-01' AND pe.UserId = '##UserId##'