I have a SQL table `user_game` which contains the games that a user owns:

```
| id | user_id | game_id |
|----|---------|---------|
| 83 | 1       | 1       |
| 84 | 1       | 2       |
| 85 | 1       | 3       |
| 86 | 2       | 2       |
| 87 | 2       | 3       |
| 88 | 2       | 4       |
| 89 | 3       | 2       |

```

*I am trying to count the number of users which have 1 game, 2 games, 3 games.. etc.*

User 1 has 3 games, User 2 has 3 games, and User 3 has 1 game. Therefore **these are the results I want to achieve**:

```
| no_of_games | COUNT(no_of_games) |
|-------------|--------------------|
| 1           | 1                  |
| 2           | 0                  |
| 3           | 2                  |

```

`COUNT(no_of_games)` is the number of users that have that number of games.

---

I can individually get the number of users for each `no_of_games` with this query:

```
-- Select no. of users with 1 game
SELECT no_of_games, COUNT(no_of_games)
FROM
(
  -- Select no. of games each user has
  SELECT user_id, COUNT(1) as no_of_games
  FROM user_game
  GROUP BY user_id
) as A
WHERE no_of_games = 1;

```

which gives the results:

```
| no_of_games | COUNT(no_of_games) |
|-------------|--------------------|
| 1           | 1                  |

```

However I have to change the `no_of_games = 1` to 2, 3, 4... manually and `UNION` them with this solution and I can't do it for ~60 cases.

Is there a simpler way to achieve this?