CSCW Up/DownMods ตามกลุ่มอายุ ไม่จำเป็นต้องใช้ตารางทั้งหมด
CSCW Up/DownMods by age group.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 VoteType, COUNT(Suggested_Edits) AS Suggested_Edits, age_cat, COUNT(DISTINCT ownerid) AS nusers FROM (SELECT SuggestedEdits.Id AS Suggested_Edits, SuggestedEdits.OwnerUserId AS ownerid, CASE WHEN age >= 15 AND age <= 39 THEN 'younger' WHEN age > 39 AND age <= 70 THEN 'veteran' END AS age_cat, VoteTypes.Name AS VoteType FROM SuggestedEdits, Users, SuggestedEditVotes, VoteTypes WHERE SuggestedEdits.OwnerUserId = Users.Id AND SuggestedEdits.Id = SuggestedEditVotes.SuggestedEditId AND SuggestedEditVotes.VoteTypeId = VoteTypes.Id AND NOT Users.age IS NULL AND Users.age BETWEEN 15 AND 70 AND Users.Reputation BETWEEN 2 AND 100000) AS X GROUP BY age_cat, votetype