I have a sql table that looks like this:
gameId team1 team2 date stage
1 5 2 xx/xx 0
2 3 4 xx/xx 0
3 7 1 xx/xx 0
5 5 3 xx/xx 8
6 7 2 xx/xx 8
7 5 3 xx/xx 5
8 7 2 xx/xx 5
I want to SELECT ALL and order group it by stage in a specific order (8, 0, 5) and within each group have it ordered by date.
I thought of doing:
SELECT * FROM table ORDER BY date DESC GROUP BY stage
But I am not sure how to give a criteria for the grouping because it does not follow a numeric logic.
The goal is to show the items by stage in the specific order I mentioned.