博客

SELECT B.*, C.matchAddress, C.matchContent, C.matchTime, D.XM, @curRank := IF(@prevRank = B.avgScore, @curRank, @incRank) AS rank, @incRank := @incRank + 1,
    @prevRank := B.avgScore
FROM (
SELECT avg(score) as avgScore, matchClassId, teacherId
from Tea_MatchTeacherScore A,  (
    SELECT @curRank :=0, @prevRank := NULL, @incRank := 1
    ) r
GROUP BY matchClassId, teacherId) B 
LEFT JOIN Tea_MatchClass C ON B.matchClassId = C.id
LEFT JOIN Tea_Teacher D ON B.teacherId = D.id
ORDER BY avgScore desc