I need help in fixing my SQL query.
I have 4 tables as below.
Products (prodid, prodname)
Suppliers (supplierid, suppliername, prodid)
customers (customerid, customername, orderid)
orders (orderid, ordername)
I want to retrieve Supplier records whose prodid is = "prod1" and count (customers) whose name = "sample customer" and count(orders) whose ordername = "some order" for that supplier.
Please help me in this question.