What is improper about this SQL?

[slowdeer]

Code: Select all

sum(if[((holdem_hand_summary.cnt_players = 4 and holdem_hand_player_statistics.position = 1) or
(holdem_hand_summary.cnt_players = 5 and holdem_hand_player_statistics.position = 2) or
(holdem_hand_summary.cnt_players = 6 and holdem_hand_player_statistics.position = 3) or
(holdem_hand_summary.cnt_players = 7 and holdem_hand_player_statistics.position = 4) or
(holdem_hand_summary.cnt_players = 8 and (holdem_hand_player_statistics.position = 4 or holdem_hand_player_statistics.position = 5)) or
(holdem_hand_summary.cnt_players = 9 and (holdem_hand_player_statistics.position = 5 or holdem_hand_player_statistics.position = 6)) or
(holdem_hand_summary.cnt_players = 10 and (holdem_hand_player_statistics.position = 6 or holdem_hand_player_statistics.position = 7)))
, 1, 0]

I can't figure it out, PT3 won't let me make this column. I just want to make a "cnt_hands_ep" column.

[WhiteRider]

You need to close the bracket for the SUM right at the end, after the ] for the IF.