SQL - Consulta entre dos tablas

mysql> SELECT * FROM tabla;

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

| id   | proveedor   | producto |

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

|    1 | proveedor 1 | platano  |

|    2 | proveedor 1 | manzana  |

|    3 | proveedor 1 | naranja  |

|    4 | proveedor 2 | platano  |

|    5 | proveedor 2 | manzana  |

|    6 | proveedor 2 | higo     |

|    7 | proveedor 2 | durazno  |

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

7 rows in set (0.11 sec)

mysql> SELECT proveedor, count(producto) total_productos

    -> FROM tabla

    -> GROUP BY proveedor

    -> ORDER BY total_productos DESC;

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

| proveedor   | total_productos |

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

| proveedor 2 |               4 |

| proveedor 1 |               3 |

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

2 rows in set (0.11 sec)