Plan-of-SQLs (Ours)


Statement: each tournament had the same result in the years 1990 and 1999

Ground-truth: FALSE

Input Table: katrina adams

Step 1: Select rows where the years are 1990 and 1999.
tournament c_1986 c_1988 c_1989 c_1990 c_1991 c_1992 c_1993 c_1994 c_1995 c_1996 c_1997 c_1998 c_1999
grand slam tournaments grand slam tournaments grand slam tournaments grand slam tournaments grand slam tournaments grand slam tournaments grand slam tournaments grand slam tournaments grand slam tournaments grand slam tournaments grand slam tournaments grand slam tournaments grand slam tournaments grand slam tournaments
australian open a 3r 3r 3r a qf 3r 2r 1r a 2r 1r 1r
french open a qf qf 3r 3r qf qf 1r qf qf 2r 3r 1r
wimbledon a sf qf 3r qf 3r 1r 2r 3r qf 3r 3r 1r
us open 1r 2r 3r 3r qf a 3r qf 3r 2r 3r 2r 1r

Step 2: Select rows where the results in the years 1990 and 1999 are the same for each tournament.
tournament c_1986 c_1988 c_1989 c_1990 c_1991 c_1992 c_1993 c_1994 c_1995 c_1996 c_1997 c_1998 c_1999
australian open a 3r 3r 3r a qf 3r 2r 1r a 2r 1r 1r
french open a qf qf 3r 3r qf qf 1r qf qf 2r 3r 1r
wimbledon a sf qf 3r qf 3r 1r 2r 3r qf 3r 3r 1r
us open 1r 2r 3r 3r qf a 3r qf 3r 2r 3r 2r 1r

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to the number of tournaments, otherwise return FALSE.
tournament c_1986 c_1988 c_1989 c_1990 c_1991 c_1992 c_1993 c_1994 c_1995 c_1996 c_1997 c_1998 c_1999

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: FALSE