Convert Snippet to Image

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

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!