Total Number of games where losing player has more Captured score than Winning player.
Hint: Captured score is cumulative, i.e., for 3rd capture it will have score for 1, 2, and 3rd.
Result attributes: total_number_of_games Final result will have only one row
There's two tables, captured_score_for_black and captured_score_for_white, can anyone just frame a query for me to understand it better?
https://imgur.com/a/TpsJNZq