Q&A about the site for practitioners of the art and science of signal, image and video processing
SELECT TOP 10 SUM(CASE WHEN a.Score > 0 THEN 1 ELSE 0 END) Accepted, COUNT(*) Total, SUM(CASE WHEN a.Score > 0 THEN 1 ELSE 0 END) * 100.0 / COUNT(*) Perc FROM Posts q LEFT JOIN Posts a ON q.AcceptedAnswerId = a.Id WHERE q.ClosedDate > DATEADD(week, -1, GETUTCDATE())