Plan-of-SQLs (Ours)


Statement: wimbledon had only one a result during the years 1986 to 1999

Ground-truth: TRUE

Input Table: katrina adams

Step 1: Select rows where 'tournament' is 'wimbledon'.
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 'c_1986' is 'a' or 'c_1988' is 'a' or 'c_1989' is 'a' or 'c_1990' is 'a' or 'c_1991' is 'a' or 'c_1992' is 'a' or 'c_1993' is 'a' or 'c_1994' is 'a' or 'c_1995' is 'a' or 'c_1996' is 'a' or 'c_1997' is 'a' or 'c_1998' is 'a' or 'c_1999' is 'a'.
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
wimbledon a sf qf 3r qf 3r 1r 2r 3r qf 3r 3r 1r

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, 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
wimbledon a sf qf 3r qf 3r 1r 2r 3r qf 3r 3r 1r

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE