---

SELECT COUNT(*)
FROM clean
WHERE bot_result = 'закрыл';

SELECT COUNT(*)
FROM clean
WHERE bot_result = 'закрыл'
  AND agent_id IS NULL;

SELECT bot_result, COUNT(*)
FROM clean
WHERE agent_id IS NULL
GROUP BY bot_result;

SELECT bot_result, COUNT(*)
FROM clean
WHERE agent_id IS NOT NULL
GROUP BY bot_result;