---

SELECT ROUND(AVG(reopened = 0 AND came_back = 0) * 100, 1)
FROM razmetka
WHERE period = 'до' AND written = 1
  AND blok = 'вторая';

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

SELECT ROUND(AVG(reopened = 0 AND came_back = 0) * 100, 1)
FROM razmetka
WHERE period = 'после' AND written = 1
  AND bot_result = 'закрыл'
  AND blok = 'вторая';