select * from s insert into s(sno, sname, sex, sdept, sage) values('0003','lili',0,'jisuanji',23); insert into s(sno, sname, sex, sdept, sage) values('0004','mao',1,'jisuanji',23); insert into s(sno, sname, sex, sdept, sage) values('0005','deng',0,'xinxi',23); insert into s(sno, sname, sex, sdept, sage) values('0006','rose',0,'xinxi',23); insert into s(sno, sname, sex, sdept, sage) values('0007','kobe',1,'xinxi',23); insert into s(sno, sname, sex, sdept, sage) values('0008','james',1,'cailiao',23); insert into s(sno, sname, sex, sdept, sage) values('0009','wade',0,'cailiao',23); select * from c insert into c(cno, cname, cpno, credit) values('001','math','003',2); insert into c(cno, cname, cpno, credit) values('002','english','004',2); insert into c(cno, cname, cpno, credit) values('003','geography','005',2); insert into c(cno, cname, cpno, credit) values('004','chemitry','006',2); insert into c(cno, cname, cpno, credit) values('005','biology','001',2); insert into c(cno, cname, cpno, credit) values('006','physics','002',2); select * from sc insert into sc(sno, cno, grade) values('0001','001',99); insert into sc(sno, cno, grade) values('0002','002',99); insert into sc(sno, cno, grade) values('0003','003',99); insert into sc(sno, cno, grade) values('0004','004',99); insert into sc(sno, cno, grade) values('0005','001',99); insert into sc(sno, cno, grade) values('0006','002',99); insert into sc(sno, cno, grade) values('0007','002',99); use student select cno, cname from c use student select cno, COUNT(sno) as num from sc group by cno having COUNT(sno) >1 order by num desc, cno asc select sname,sage from s where sex=1 and (sage>= (select AVG(sage) from s where sex=0 ) )