Select Date greater than now order newest to oldest

[B R]

I'm wanting to select a series of games, where the game date is greater than now being un-played.

I want to order them by date oldest to newest (oldest game first then last one being the very next game to play).

I need to order DESC to get them oldest to newest but I'm getting games for later in the season, assume I only want the last 8 records. Limiting to 8 is giving me the first 8 records not the last 8?

How can I achieve this?




SELECT g.gameId, g.kickOff, v. timezone,
CONVERT_TZ (g.kickOff, v.timezone, 'America/Chicago') as ServerTime,
now()
FROM games g
JOIN venues v ON g.venueId = v.venueId
WHERE CONVERT_TZ (g.kickOff, v.timezone, 'America/Chicago') > now()
ORDER BY CONVERT_TZ (g.kickOff, v.timezone, 'America/Chicago') DESC