Plan-of-SQLs (Ours)


Statement: the total rebounds of player herb estes are 734

Ground-truth: TRUE

Input Table: none

Step 1: Select rows where 'player' is 'herb estes'.
rank player years games reb_avg total_rebounds
1 jim nowers 1972 - 1976 112 9.4 1048
2 kenny sanders 1985 - 1989 107 9.6 1026
3 will thomas 2004 - 2008 131 7.6 993
4 george evans 1997 - 2001 116 8.2 953
5 robert dykes 1987 - 1991 122 7.5 925
6 andre gaddy 1977 - 1982 98 9.3 916
7 jai lewis 2002 - 2006 125 7.2 895
8 rob rose 1982 - 1986 113 7.1 805
9 herb estes 1973 - 1976 80 9.2 734
10 jesse young 1999 - 2003 115 6.2 708

Step 2: Select rows where 'total_rebounds' is 734.
rank player years games reb_avg total_rebounds
9 herb estes 1973 - 1976 80 9.2 734

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
rank player years games reb_avg total_rebounds
9 herb estes 1973 - 1976 80 9.2 734

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE