Let's say I have 3 tables:

Table 1 called "states":

```
id | state
1    italy
2    netherlands
3    russia

```

Table 2 called "hotels":

```
id | hotel name | belongsToCountry
1    Green Hotel  2
2    Luxurious    2
3    Get Warm!    3

```

Table 3 called "free rooms":

```
id | roomID | belongsToHotel
1    815      2
2    912      2
3    145      1
4    512      1
5    1200     3

```

Now, what I need to echo is this:

> 
> Netherlands has 4 free rooms.  
> 
>  Russia has 1 free room.
> 
> 
> 

In words:
I need to make a list of **all states** which have **at least 1 free room** and I need to return the exact value of **how many free rooms there are**.

If anyone can help me with this, I'd be so grateful!