分别用一条SQL语句完成以下题目的操作: 1. 查询年龄为19岁的女同学的学号和姓名
发布网友
发布时间：2022-05-22 13:54
共1个回答
热心网友
时间：2024-03-08 13:41
select sno,sname from s where ssex='女' and sage=19
2
select cname,clocation from c where clocation='主楼' order by teacher
3
select sno from sc where grade>=80 and cno in (select cno from c where cname='数据库原理')
4
select s.sno,s.sname,avg(grade) from s,c,sc where s.sno=sc.sno and c.cno=sc.cno group by s.sno,s.sname
5
selete from sc where cno in (select cno from sc group by cno having count(*)<=10)
