mysql> select source_server,count(email) from member group by source_server;
+-----------------+--------------+
| source_server   | count(email) |
+-----------------+--------------+
| ACPETOPGAN      |            1 |
| ACPTUNSYIAH     |           51 |
| DEFAULT         |            4 |
| GDLHUB          |          268 |
| IJPTUNCEN       |            7 |
| JBPEISMAIL      |            1 |
| JBPTIPBMMA      |           84 |
| JBPTITBPP       |         2610 |
| JBPTITBPSUD     |            1 |
| JIIYPIA         |            6 |
| JIPTSTIKOMSBY   |            5 |
| JIPTUMM         |           67 |
| JIUNUMM         |            2 |
| JKDMLFORLINK    |            2 |
| JKLPNDPDII      |            4 |
| JKPKBPPK        |           37 |
| JKPKELNUSA      |           35 |
| JKPTBINUS       |          130 |
| JKPTPERBANAS    |           10 |
| JKPTYARSI       |           18 |
| JKUNUAJ         |            6 |
| KSPTIAIN        |           10 |
| RIPTIAIN        |           10 |
| SAPTUNSRAT      |           36 |
| SBPTIAIN        |           11 |
| SGPTUNHALU      |           20 |
| SUPTIAIN        |           10 |
| TESTINSTITUTION |           33 |
+-----------------+--------------+
28 rows in set (0.13 sec)

mysql> select country,count(email) from member group by country;
+----------------------+--------------+
| country              | count(email) |
+----------------------+--------------+
|                      |            5 |
| Aceh                 |            1 |
| Andorra              |            1 |
| Australia            |            7 |
| Bangladesh           |            1 |
| Belgium              |            2 |
| Brazil               |            1 |
| Brunei               |            1 |
| Brunei Darussalam    |            2 |
| Bulgaria             |            1 |
| Canada               |           10 |
| Chile                |            1 |
| Czech Republic       |            2 |
| Egypt                |            3 |
| Germany              |            6 |
| Hongkong, PRC        |            1 |
| India                |            3 |
| Indonesia            |         3349 |
| Iran                 |            1 |
| Japan                |            8 |
| JapanIsia            |            1 |
| Jepang               |            1 |
| Jerman               |            1 |
| Lebanon              |            1 |
| Malaysia             |           16 |
| Morocco              |            1 |
| Netherland           |            1 |
| Netherlands          |            2 |
| Pakistan             |            1 |
| qatar                |            1 |
| Romania              |            1 |
| Saudi Arabia         |            3 |
| Singapore            |            7 |
| Spain                |            3 |
| Sweden               |            1 |
| Thailand             |            1 |
| The                  |            1 |
| The Netherlands      |            1 |
| uae                  |            1 |
| UK                   |            1 |
| United               |            1 |
| United Arab Emirates |            1 |
| United Kingdom       |            6 |
| United States        |            9 |
| US                   |            3 |
| USA                  |            3 |
| Viet Nam             |            1 |
| Vietnam              |            3 |
+----------------------+--------------+
48 rows in set (0.15 sec)

mysql> select idjob_type,count(email) from member group by idjob_type;
+------------+--------------+
| idjob_type | count(email) |
+------------+--------------+
|          0 |           12 |
|          1 |           52 |
|          2 |          256 |
|          3 |         1413 |
|          4 |          243 |
|          5 |           37 |
|          6 |           47 |
|          7 |          176 |
|          8 |          141 |
|          9 |          207 |
|         10 |          102 |
|         11 |          306 |
|         12 |           95 |
|         13 |           30 |
|         14 |          111 |
|         15 |          251 |
+------------+--------------+
16 rows in set (0.12 sec)

mysql> select dc_type,count(idmetadata) from metadata group by dc_type;
+---------+-------------------+
| dc_type | count(idmetadata) |
+---------+-------------------+
| book    |              1220 |
| clipp   |                19 |
| course  |                55 |
| dlearn  |                53 |
| expert  |                28 |
| grey    |               329 |
| jou     |               245 |
| mmedia  |               156 |
| proc    |               199 |
| publ    |                32 |
| quiz    |                 5 |
| res     |               443 |
| s1      |               145 |
| s2      |               354 |
| s3      |                 6 |
| sw      |                17 |
| web     |                38 |
+---------+-------------------+
17 rows in set (0.38 sec)