SELECT supplier_id FROM Product_Suppliers GROUP BY supplier_id HAVING avg(total_amount_purchased)  >  50000 OR avg(total_amount_purchased)  <  30000
Find the id of suppliers whose average amount purchased for each product is above 50000 or below 30000.
SELECT supplier_id FROM Product_Suppliers GROUP BY supplier_id HAVING avg ( total_amount_purchased ) > 50000 OR avg ( total_amount_purchased ) < 30000
select supplier_id from product_suppliers group by supplier_id having avg ( total_amount_purchased ) > value or avg ( total_amount_purchased ) < value
Find the id of suppliers whose average amount purchased for each product is above 50000 or below 30000 .