Plan-of-SQLs (Ours)

Statement: with a tie no 2 , sheffield wednesday is home team

Ground-truth: TRUE

Input Table: 1983 - 84 fa cup

Step 1: Select rows where 'tie_no' is 2.
tie_no home_team score away_team date
1 notts county 1 - 2 everton 1984-03-10
2 sheffield wednesday 0 - 0 southampton 1984-03-11
replay southampton 5 - 1 sheffield wednesday 1984-03-20
3 plymouth argyle 0 - 0 derby county 1984-03-10
replay derby county 0 - 1 plymouth argyle 1984-03-14
4 birmingham city 1 - 3 watford 1984-03-10
Step 2: Select rows where 'home_team' is 'sheffield wednesday'.
tie_no home_team score away_team date
2 sheffield wednesday 0 - 0 southampton 1984-03-11
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
tie_no home_team score away_team date
2 sheffield wednesday 0 - 0 southampton 1984-03-11
Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE