Is the formula correct?

Question

SQL

Good afternoon. Is the formula correct? I need a strict match by numbers and the formula does not output correctly?

select date , date_update , game_id , game , command1_score_current ,  command2_score_current , command1_avgrating , command2_avgrating , index_1 , index_2 , index_goal_1 from table_football3
where game_id in (
  select game_id from table_football3 FOR SYSTEM_TIME ALL
  where  index_goal_group = 0.5 and index_goal_1 >= 1.5 and (abs(command1_avgrating - command2_avgrating) >= 0.5)
  group by game_id)

data

Answer 1

in a subquery you can try select distinct game_id
and removegroup by game_id