Create a query that returns a list of manufacturers (manufacturer_id), the number of unique customers who have placed an order with that manufacturer (customer count), and the number of unique products that have been ordered from that manufacture (product count). limit your results to manufacturers who have sold to at least 100 different customers and at least 10 different products

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).

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.

you go to add your answer type bewteen 5000 and 20 characters and can only have 2 people answer on 1 question.your challanges are based on your questions.

the only way i would see could be an autoclicker type software. but that is very time consuming.