查询请教

create table aa{
  id int ,
  number int,
  card int
}

insert into (1,22,1);
insert into (2,12,1);
insert into (3,2,1);
insert into (4,22,2);
insert into (5,22,2);
insert into (6,22,2);
insert into (7,22,2);
insert into (8,22,2);
insert into (9,22,3);
insert into (10,22,3);

我想要查询出 card 相同的时候 number的总和

SQL code

select count(distinct card) from aa 

SQL code

select count(distinct number) from aa where card = "相同的数";

SQL code

select card,sum(number) from aa group by card