Hello All,
I have recently opened a website that allows users to run there own online racing championship. This site has an admin page where the user can insert the race results of there online races into the database. This then stores the points drivers get for the championship and displays the race results and championship standings tables accordingly.
Here's my problem. When two (or more) drivers are on the same points. The driver with the most race wins takes the highest position on the championship standings table.
example:
1st Charlie - 35 points, 3 wins
2nd Fred - 35 points, 2 win
3rd Nigel - 28 points, 1 win
Charlie, although has the same points in this table is first because he has 3 wins compared to Fred's 2 wins.
So here is my question. Is it posible to have an sql query that can order by points and then by wins at the same time?
