SQL sum的用法

KSMC DAYS
呼吸内科 1
呼吸内科 6
急诊科 14
急诊科 1
急诊科 5

用SQL语句怎么使其变
KSMC DAYS
呼吸内科 7
急诊科 20

---

select ksmc,sum(days)as days from 表group by ksmc

---

select Ksmc, sum(days) as days from table group by ksmc
希望采纳

---

select count(*),days from table_name group by ksmc;

---