instruction: Votes received on answers to closed questions vs votes received on all answers.
response: SELECT * FROM (SELECT u.Id, u.DisplayName, SUM(a.Score) AS allVotes, SUM(a.Score * CASE WHEN q.ClosedDate IS NULL THEN 0 ELSE 1 END) AS closedVotes FROM Users AS u JOIN Posts AS a ON a.PostTypeId = 2 AND u.Id = a.OwnerUserId JOIN Posts AS q ON q.Id = a.ParentId GROUP BY u.Id, u.DisplayName) AS x WHERE x.allVotes > 1000 ORDER BY x.closedVotes / x.allVotes DESC