SQL query for table with multiple keys?

Vote count: 0

I am sorry if this seems too easy but I was asked this question and I couldn't answer even after preparing SQL thoroughly :(. Can someone answer this?

There's a table - Seller id, product id, warehouse id, quantity of products at each warehouse for each product as per each seller.

We have to list the Product Ids with Seller Id who has highest number of products for that product and the total number of units he has for that product.

I think I got confused because there were 3 keys in the table.

asked 44 secs ago

abhishek

Let's block ads! (Why?)

SQL query for table with multiple keys?