instruction: Most effective Illuminators with accept rate. Illuminator badge holders ranked by their effectiveness; percentage of their answers that qualify for the badge times the number of qualifying answers. This gives a better ranking for how effectively people have improved the original question (how often they edited the question compared to the number of answers they gave).
response: SELECT ct AS "total_answers", accept AS "accepted_answers", accept * 100 / ct AS "accept_rate" FROM (SELECT COUNT(*) AS ct, SUM(CASE WHEN q.AcceptedAnswerId = a.Id THEN 1 ELSE 0 END) AS accept FROM Posts AS q JOIN Posts AS a ON a.ParentId = q.Id WHERE q.PostTypeId = 1 AND a.ClosedDate IS NULL AND q.ClosedDate IS NULL AND a.PostTypeId = 2 AND a.OwnerUserId = '##UserId##') AS sub