[![enter image description here](https://i.stack.imgur.com/b7ZkW.png)](https://i.stack.imgur.com/b7ZkW.png)

The question is that List the SUPPLIER\_ID, supplier NAME and the number of products each supplier has provided. List only those that have supplied more than 2 products. [Use PRODUCT and SUPPLIER tables]

```
SELECT  S.SUPPLIER_ID, S.NAME, COUNT(S.PRODUCT_ID)
FROM PRODUCT P, SUPPLIER S
WHERE P.SUPPLIER_ID = S.SUPPLIER_ID
GROUP BY NAME;

SELECT SUPPLIER_ID,  COUNT(PRODUCT_ID)
FROM SUPPLIER, PRODUCT
WHERE  SUPPLIER.SUPPLIER_ID = PRODUCT.SUPPLIER_ID
GROUP BY NAME;

```

I tried the both ways, but they won't work. What are problems?