通过值计算多行的总和

Question

我有一张桌子

user_name     id      status          calls
===========================================
apple        21       cars              67
apple        21       bikes             85
apple        21       skates            6
apple        21       pajs              56
orange       34       bikes             9
orange       34       disks             3
orange       34       cars              21
orange       34       pajs              76

我想把汽车、自行车和溜冰鞋以及每个user_name对status's的所有调用加起来。我精通SUM，但经过几个小时的深夜尝试，我非常清楚这还需要更多的东西。有谁能告诉我怎么走吗？

My Table

Answer 1

select user_name, status, sum(calls) as calls
from table
where status in ('cars', 'bikes', 'skates')
group by user_name, status