主要讲了嵌套查询，和order by group by having

select Name

from s

where s# IN

  select s#

 from sc

where c# IN

 select c#

  from c

where teacher='liu'