Plan-of-SQLs (Ours)


Statement: there were 2.4 blocks per game during the season where the field goal percentage was 594 (2nd)

Ground-truth: TRUE

Input Table: list of career achievements by dwight howard

Step 1: Select rows where 'field_goal_percentage' is 594.
selection month season team_record points_per_game field_goal_percentage rebounds_per_game blocks_per_game
9999-01-01 2006-04-01 2005-06-01 7-2 18.1 531 14.0 0.7
9999-01-02 2006-10-01 2006-07-01 12-4 17.1 576 13.6 1.9
9999-01-03 2007-10-01 2007-08-01 14-4 23.8 618 15.0 2.7
9999-01-04 2007-12-01 2007-08-01 8-7 21.7 598 16.1 2.9
9999-01-05 2010-10-01 2010-11-01 13-4 21.8 (5th) 594 (2nd) 12.1 (4th in league) 2.4

Step 2: Select rows where 'blocks_per_game' is 2.4.
selection month season team_record points_per_game field_goal_percentage rebounds_per_game blocks_per_game

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
selection month season team_record points_per_game field_goal_percentage rebounds_per_game blocks_per_game

Final output table:
verification_result
FALSE

Prediction: FALSE

Ground-truth: TRUE