Plan-of-SQLs (Ours)


Statement: the lowest attendance figure for a game was 32343

Ground-truth: TRUE

Input Table: 1983 miami dolphins season

Step 1: Select rows where 'attendance' is less than or equal to 32343.
week date opponent result attendance
1 1983-09-04 buffalo bills w 12 - 0 78715
2 1983-09-11 new england patriots w 34 - 24 59343
3 1983-09-19 los angeles raiders l 27 - 14 57796
4 1983-09-25 kansas city chiefs w 14 - 6 50785
5 1983-10-02 new orleans saints l 17 - 7 66489
6 1983-10-09 buffalo bills l 38 - 35 59948
7 1983-10-16 new york jets w 32 - 14 58615
8 1983-10-23 baltimore colts w 21 - 7 32343
9 1983-10-30 los angeles rams w 30 - 14 72175
10 1983-11-06 san francisco 49ers w 20 - 17 57832
11 1983-11-13 new england patriots l 17 - 6 60771
12 1983-11-20 baltimore colts w 37 - 0 54482
13 1983-11-28 cincinnati bengals w 38 - 14 74506
14 1983-12-04 houston oilers w 24 - 17 39434
15 1983-12-10 atlanta falcons w 31 - 24 56725
16 1983-12-16 new york jets w 34 - 14 59975

Step 2: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
week date opponent result attendance
8 1983-10-23 baltimore colts w 21 - 7 32343

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE