---

SELECT blok,
       ROUND(AVG(reopened = 0 AND came_back = 0) * 100, 1)
FROM razmetka
WHERE period = 'до' AND written = 1
GROUP BY blok
ORDER BY blok;

SELECT blok,
       ROUND(AVG(reopened = 0 AND came_back = 0) * 100, 1)
FROM razmetka
WHERE period = 'после' AND written = 1
GROUP BY blok
ORDER BY blok;

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