sql - SQL 平均价格

Question

我需要一个显示制造商名称和平均价格的 SQL 查询。谢谢

表 1 产品

+----+---------+-------+--------------+
| ID | Product | Price | Manufacturer |
+----+---------+-------+--------------+
|  1 | Game1   |   100 |            1 |
|  2 | Game2   |    50 |            2 |
|  3 | Game4   |    70 |            1 |
+----+---------+-------+--------------+

表 2 制造商

+----+-----------+
| Id |   Name    |
+----+-----------+
|  1 | Sony      |
|  2 | Microsoft |
+----+-----------+

标签： sqlinner-joinaverageaggregate-functions

Answer 1

只需加入和聚合：

select m.name, avg(p.price) avg_price
from manufacturer m
inner join products p on p.manufacturer = m.id
group by m.id, m.name