instruction: What is my accepted answer percentage rate. On avg how often are answers I give, accepted
response: SELECT COUNT(*) AS answers, COUNT(q.Id) AS accepted, CAST(COUNT(q.Id) AS FLOAT) / COUNT(*) * 100 AS AcceptedPercentage FROM Posts AS a LEFT JOIN Posts AS q ON q.AcceptedAnswerId = a.Id WHERE a.PostTypeId = 2