---

SELECT topic, COUNT(*),
       SUM(came_back), SUM(reopened),
       ROUND(AVG(came_back) * 100, 1),
       ROUND(AVG(reopened) * 100, 1)
FROM clean
WHERE period = 'до'
GROUP BY topic
ORDER BY topic;