Find pairs of new users who are the 'accepted answer' of each other's questions more than once By new users we mean accounts that have been open under a month. Don't include posters answering their own questions or posts without owners.
Q&A about the site for developers and users of elementary OS and applications
SELECT Users.Id, Users.CreationDate, Posts.AcceptedAnswerID, Posts.OwnerUserID FROM Users, Posts /* LEFT JOIN Posts ON Users.Id = Posts.OwnerUserId */ WHERE Users.CreationDate > GETDATE() - 30 AND Posts.AcceptedAnswerID IS NOT NULL ORDER BY Users.CreationDate DESC; /*SELECT t1.EmpNo, t1.LastName, t1.BirthDate, t2.EmpNo, t2.LastName, t2.Birthdate FROM Employee t1, Employee t2 WHERE t1.BirthDate = t2.Birthdate AND t1.EmpNo <> t2.EmpNo*/