Q&A for information security professionals
SELECT u.Id AS [User Link], COUNT(*) AS 'Accepted Answers' FROM Users AS u LEFT JOIN Posts AS p1 ON p1.OwnerUserId=u.Id LEFT JOIN Posts AS p2 ON p2.AcceptedAnswerId=p1.Id WHERE p2.Id IS NOT NULL GROUP BY u.Id HAVING COUNT(*) >= 700 ORDER BY COUNT(*) DESC;