serie/reeks op basis van datetime bepalen

SELECT
g.Game_Played,
g.Season_ID,
g.Game_DateTime,
g.Home_Team_ID,
g.Away_Team_ID,
g.Home_Score_FT,
g.Away_Score_FT,
g.GameType_ID,
IF(g.Home_score_FT>g.Away_score_FT AND g.Home_Team_ID < 4,1,0) AS home_win,
IF(g.Home_score_FT=g.Away_score_FT AND g.Home_Team_ID < 4,1,0) AS home_draw,
IF(g.Home_score_FT<g.Away_score_FT AND g.Home_Team_ID < 4,1,0) AS home_lose
FROM
adofans.af_games g
WHERE g.Game_Played ='Y'
and g.Home_Team_ID < '4'
and g.GameType_ID = '1'
Order by g.Game_DateTime;

SELECT
g.Game_Played,
g.Season_ID,
g.Game_DateTime,
g.Home_Team_ID,
g.Away_Team_ID,
g.Home_Score_FT,
g.Away_Score_FT,
g.GameType_ID,
IF(g.Home_score_FT>g.Away_score_FT AND g.Home_Team_ID < 4,1,0) AS home_win,
IF(g.Home_score_FT=g.Away_score_FT AND g.Home_Team_ID < 4,1,0) AS home_draw,
IF(g.Home_score_FT<g.Away_score_FT AND g.Home_Team_ID < 4,1,0) AS home_lose
FROM
adofans.af_games g
WHERE g.Game_Played ='Y'
AND g.Home_Team_ID < '4'
AND g.GameType_ID = '1'
ORDER BY g.Game_DateTime;