SELECT f2.id, f1.name, f2.score FROM language AS f1, (SELECT id, language_id, score FROM (SELECT id, language_id, score, dense_rank() OVER(PARTITION BY language_id ORDER BY score DESC) AS ranking FROM grade) AS f WHERE ranking <= 2) AS f2 WHERE f1.id = f2.language_id ORDER BY f1.`name` ASC, f2.sc...