---

TITLE = "Вторая линия: без переоткрытия и возврата"
YLABEL = "Доля обращений, %"

SERIES = [
    ("Люди до апреля", """
        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;
    """),
]