Which of those suppliers purchased less than 30000?
SELECT supplier_id FROM Product_Suppliers GROUP BY supplier_id HAVING avg ( total_amount_purchased )  < 30000
purchased less than 30000 refers to HAVING AVG(total_amount_purchased) < 30000;