Answer:
select manufacturer_id from manufacturer where (DISTINCT(customer)==customer count) AND (DISTINCT(product)== product count) and (no_of_Customer>=100)and(no, of products>=10).
Step-by-step explanation:
In the above distinct is used to find the unique customer and product. And since the conditions must be fulfilled and all of them, hence AND operator has been used to join them all. select and where usage is self explanatory and also checked are the least number of products and customers. Product count and customer count have been used as mentioned.