need to select groups with common names

[attaboy]

I have a table called countries with 3 columns  name, language, and population.  I need to find a query that list groups of countries that have the same language so if I have 10 countries and 3 of them speak English, 2 speak German and the other countries speak unique languages my output would list the English and German speaking countries.  I have to do this with a mysql query only no php.  

[attaboy]

never mind I found a solution

 

;

|

+--------------------------------------------------------------------------------------------------------------

------------------+

1 row in set (0.00 sec)

 

mysql> SELECT *

    -> FROM countries

    -> WHERE primary_language IN

    -> (

    -> SELECT primary_language FROM countries

    -> GROUP BY primary_language

    -> HAVING COUNT(primary_language) > 1

    -> )

    -> ORDER BY primary_language;

+-----------+------------------+------------+

| name      | primary_language | population |

+-----------+------------------+------------+

| Austrilia | English          |  22851000 |

| Canada    | English          |  34730000 |

+-----------+------------------+------------+

2 rows in set (0.00 sec)