This is the code i got so far   

```
SELECT users_ID,Problem_ID 
FROM 'submission'
WHERE Status = "AC" 
GROUP BY users_ID,Problem_ID 

```

I am getting these results

```
+----------+------------+
| Users_ID | Problem_ID |
+----------+------------+
|        1 |          1 |
|        1 |          2 |
|        1 |          3 |
|        2 |          1 |
|        2 |          3 |
+----------+------------+

```

I only want to get
------------------

```
+----------+------------+
| Users_ID | Problem_ID |
+----------+------------+
|        1 |          3 | --  so because there are 3 results for user_ID 1
|        2 |          2 | -- and there are 2 results for user_ID 2
+----------+------------+

```

So the `Problem_ID` is how many rows I am getting from my query for each user.  

But how do I accomplish this? 

Edit:
-----

I forgot mention that the table contains duplicates of the same problem for example.  

I got a `Problem` with the `ID` of `1` and then in the database there could be two rows with the same user and with status as `"AC"` but I want to only get one of them.