SELECT agent_code,COUNT(agent_code),MAX(ord_amount) FROM orders GROUP BY agent_code HAVING MAX(ord_amount) IN(500,800,2000);