查询所有姓“李”的学生所有成绩

SELECT r.Studentno AS '"李"同学学号',studentname AS '姓名',StudentResult AS '成绩'
FROM result AS r
INNER JOIN student AS s
ON r.StudentNo=s.StudentNo AND studentname LIKE CONCAT('李','%')