---

SELECT agent_id, COUNT(*)
FROM clean
GROUP BY agent_id
ORDER BY agent_id;

SELECT COUNT(*)
FROM clean
WHERE agent_id IS NULL;

SELECT DISTINCT id, login
FROM agents
ORDER BY id;