curtwagner1984
Newbie
- Nov 21, 2017
- 22
- 45
- 58
I'm unsure if the option doesn't exist or I just can't find it.
What I'm asking is how to list games by date (so from the newest updated to the oldest) but I want the results to showing up to have at least 4 stars.)
The only option I currently see is to sort games by rating (so from highest to lowest rating) but this is not what I want.
Basically in SQL psuedocode what I want is:
What I'm asking is how to list games by date (so from the newest updated to the oldest) but I want the results to showing up to have at least 4 stars.)
The only option I currently see is to sort games by rating (so from highest to lowest rating) but this is not what I want.
Basically in SQL psuedocode what I want is:
Code:
SELECT * FROM (GAMES) ORDER BY (DATE DESC) WHERE (GAME.RATING >4)