instruction: Users with many answers with a high VLQ survival ratio.
response: SELECT OwnerUserId AS "user_link", OwnerUserId AS Id, DENSE_RANK() OVER (ORDER BY VLQAnswerCount DESC) AS VLQRank, DENSE_RANK() OVER (ORDER BY AnswerCount DESC) AS AnswerRank FROM (SELECT Posts.OwnerUserId, MIN(Users.Reputation) AS Reputation, MIN(AnswerStat.AnswerCount) AS AnswerCount, COUNT(*) AS VLQAnswerCount FROM ReviewTasks, Posts, Users LEFT JOIN (SELECT OwnerUserId, COUNT(*) AS AnswerCount FROM Posts WHERE PostTypeId = 2 GROUP BY OwnerUserId) AS AnswerStat ON Users.Id = AnswerStat.OwnerUserId WHERE ReviewTasks.ReviewTaskTypeId = 3 AND Posts.Id = ReviewTasks.PostId AND Posts.OwnerUserId = Users.Id AND Posts.PostTypeId = 2 GROUP BY Posts.OwnerUserId) AS Raw ORDER BY VLQAnswerCount DESC, OwnerUserId