查询“李欣”教师任课的课程号，选修其课程的学生的学号和成绩
兄弟字段给出来啊，不然怎么写
select * from student where student.class_id in(select class_id from teacher where teacher.name='李欣')
大概就这样