[Solved] MySQL SELECT and ORDER BY [closed]
Consider the following data set… DROP TABLE IF EXISTS results; CREATE TABLE results (id_competitor INT NOT NULL ,score INT NOT NULL ,id_route INT NOT NULL ,PRIMARY KEY(id_competitor,id_route) ); INSERT INTO results VALUES (1,100,2), (2,100,2), (3,60,2), (4 ,60,2), (1,70,1), (2,80,1), (3,70,1), (4,100,1); SELECT * FROM results; +—————+——-+———-+ | id_competitor | score | id_route | +—————+——-+———-+ | … Read more