MYSQL, 按照两列来分组的一条SQL ，求助

Question

数据是这样user_id   goods_id  numbers
1         1         5
2         2         1
3         3         1
4         4         3
5         1         5
6         2         3
1         2         6
1         3         3
1         4         2
2         1         1
3         1         2
3         1         8每个用户四种类型的商品的数量查询每个用户，每种商品的数量比如
用户ID  类型      数量
1        1         5
1        2         6
1        3         4
1        4         2
2        1         1
2        2         1类似的结果，求助

Answer 1

select user_id,goods_id,max(numbers) from tt group by user_id,goods_id

Answer 2

select user_id,goods_id,sum(numbers) from tt group by user_id,goods_id

Answer 3

select user_id,goods_id,sum(numbers)
from 数据是这样
group by user_id,goods_id