I'm currently working on a java application that can get me the number of subscribers of each mobile network operator.
To do so, I've created a table with all the operators I called it indicatifs and it contains the 3 rows: country, operator and mobile\_prefix.
My second table, called subs contains two rows: mobile\_prefix and number of subscribers
What query should I use in order to get something like this:

```
Operator   Country   Number of Subscribers
SFR        France    20000
T-Mobile   USA       10250
Telia      Sweden    5248

```

..
any kind of help would be really appreciated.
Thanks!