我有下表:
+------+-----------+-------------+--------------+
| year | team_name | player_name | total_points |
+------+-----------+-------------+--------------+
| 1992 | Magic | Shaq | 2000 |
+------+-----------+-------------+--------------+
| 1992 | Magic | Steve Kerr | 4000 |
+------+-----------+-------------+--------------+
| 1996 | Lakers | Shaq | 2300 |
+------+-----------+-------------+--------------+
| 1996 | Lakers | Magic | 1000 |
+------+-----------+-------------+--------------+
| 2004 | Heat | Shaq | 3000 |
+------+-----------+-------------+--------------+
我正在试着写一个查询,找出沙克得分最多的所有球队.
以下是我的try :
SELECT year, team, MAX(total_points) FILTER(WHERE player_name = 'Shaq'
FROM basketball
GROUP BY year, team;
这显然是不正确的.我想我没有正确地使用过滤器,因为我找不到沙克得分最多的球队
正确的表应该只有第三行和最后一行