pta MYSQL 训练题集(41-60)

10-41 查询课程成绩最高二人

select a.sno,sname,grade
from
(
    select sno,grade
    from sc
    where cno = 'C002'
    order by grade desc
    limit 2
) as a,stu
where a.sno = stu.sno

10-42 查询选修张老师讲授所有课程的学生

select sname
from stu
where sno in
(
    select sno
    from sc
    where cno in (select cno from cou where teacher = '张老师')
    group by sno
    having count(*) = (select count(*) from cou where teacher = '张老师')
) 

10-43 sql-insert-sample

insert into Student
values
(99,'test')

10-44 sql-delete-sample

delete from Student
where id > 50

10-45 添加一