---

SELECT blok, COUNT(*),
       ROUND(AVG(bot_result = 'закрыл') * 100, 1)
FROM razmetka
WHERE period = 'после' AND written = 1
GROUP BY blok
ORDER BY blok;