---

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