Plan-of-SQLs (Ours)


Statement: on april 29th , 2012 the score in the final was 4 - 6 , 3 - 6

Ground-truth: TRUE

Input Table: fabio fognini

Step 1: Select rows where 'date' is '2012-04-29'.
outcome date tournament surface opponent_in_the_final score_in_the_final
runner - up 2012-04-29 brd năstase ţiriac trophy , bucharest , romania clay gilles simon 4 - 6 , 3 - 6
runner - up 2012-09-23 st petersburg open , st petersburg , russia hard (i) martin kližan 2 - 6 , 3 - 6
winner 2013-07-14 stuttgart open , stuttgart , germany clay philipp kohlschreiber 5 - 7 , 6 - 4 , 6 - 4
winner 2013-07-21 international german open , hamburg , germany clay federico delbonis 4 - 6 , 7 - 6 (10 - 8) , 6 - 2
runner - up 2013-07-28 atp vegeta croatia open umag , umag , croatia clay tommy robredo 0 - 6 , 3 - 6

Step 2: Select rows where 'score_in_the_final' is '4 - 6 , 3 - 6'.
outcome date tournament surface opponent_in_the_final score_in_the_final
runner - up 2012-04-29 brd năstase ţiriac trophy , bucharest , romania clay gilles simon 4 - 6 , 3 - 6

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
outcome date tournament surface opponent_in_the_final score_in_the_final
runner - up 2012-04-29 brd năstase ţiriac trophy , bucharest , romania clay gilles simon 4 - 6 , 3 - 6

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE