select _id,scorefrom choosewhere courseid='c1' and score<(select score from choose where _id=(select _id from student where name='张三'))应该是这样吧
