Plan-of-SQLs (Ours)


Statement: greg ostertag went to oregon state and played for the jazz from 1988 - 90

Ground-truth: FALSE

Input Table: utah jazz all - time roster

Step 1: Select rows where 'player' is 'greg ostertag'.
player nationality position years_for_jazz school___club_team
mehmet okur turkey forward - center 2004 - 11 efes pilsen ( turkey )
josã ortiz puerto rico center 1988 - 90 oregon state
greg ostertag united states center 1995 - 2004 , 2005 - 06 kansas
dan o 'sullivan united states center 1990 - 91 fordham
andre owens united states guard 2005 - 06 houston

Step 2: Select rows where 'school___club_team' is 'oregon state'.
player nationality position years_for_jazz school___club_team
greg ostertag united states center 1995 - 2004 , 2005 - 06 kansas

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
player nationality position years_for_jazz school___club_team

Final output table:
verification_result
FALSE

Prediction: FALSE

Ground-truth: FALSE