Plan-of-SQLs (Ours)


Statement: draft pick number 155 comes from arizona university

Ground-truth: TRUE

Input Table: 1990 buffalo bills season

Step 1: Select rows where 'pick' is 155.
round pick player position college
1 16 james williams defensive back fresno state
2 43 carwell gardner running back louisville
3 70 glenn parker guard arizona
4 101 eddie fuller running back lsu
6 155 john nies punter arizona
7 167 brent griffith guard minnesota - duluth
7 171 brent collins linebacker carson - newman
7 182 fred deriggi nose tackle syracuse
8 209 marvcus patton middle linebacker ucla
9 239 clarkston hines wide receiver duke
10 266 mike lodish defensive tackle ucla
11 293 al edwards wide receiver northwestern state , la

Step 2: Select rows where 'college' is 'arizona'.
round pick player position college
6 155 john nies punter arizona

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
round pick player position college
6 155 john nies punter arizona

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE