sql having group by练习

create table qwe(id int not null primary key auto_increment,
name char(10),
course char(10),age int,gender char,college char(10),year int);

insert into qwe values(null,'华华','python',25,'女','清华',2007);
insert into qwe values(null,'涛哥','java',30,'男','清华',2007);

insert into qwe values(null,'土豆','全程班',24,'女','清华',2008);

insert into qwe values(null,'happy','java',22,'男','哈工大',2007);

insert into qwe values(null,'歪歪','java',28,'男','哈工大',2008);

insert into qwe values(null,'小简','python',25,'女','哈工大',2008);

insert into qwe values(null,'亚蒙','全程班',26,'男','哈工大',2008);

insert into qwe values(null,'可可','测试开发',27,'女','哈工大',2009);

insert into qwe values(null,'雨泽&#