mysql学生成绩表例题

#查询姓张的每一个学生的最低分大于60的学号和姓名

SELECT r.studentno,studentname
FROM result r
INNER JOIN student s
ON r.`studentno`=s.`studentno`
WHERE s.`studentname` LIKE "张%" 
GROUP BY r.`studentno`
HAVING MIN(r.`score`)>60;SELECT r.studentno,st