Plan-of-SQLs (Ours)


Statement: nominee for best costume design in 2005 at the tony awards was qilliam ivey long

Ground-truth: TRUE

Input Table: la cage aux folles (musical)

Step 1: Select rows where 'award' is 'tony award'.
year award category nominee result
2005 tony award best revival of a musical best revival of a musical won
2005 tony award best performance by a leading actor in a musical gary beach nominated
2005 tony award best choreography jerry mitchell won
2005 tony award best costume design william ivey long nominated
2005 drama desk award outstanding revival of a musical outstanding revival of a musical won
2005 drama desk award outstanding choreography jerry mitchell won
2005 drama desk award outstanding costume design william ivey long nominated

Step 2: Select rows where 'category' is 'best costume design'.
year award category nominee result
2005 tony award best revival of a musical best revival of a musical won
2005 tony award best performance by a leading actor in a musical gary beach nominated
2005 tony award best choreography jerry mitchell won
2005 tony award best costume design william ivey long nominated

Step 3: Select rows where 'year' is 2005.
year award category nominee result
2005 tony award best costume design william ivey long nominated

Step 4: Select rows where 'nominee' is 'william ivey long'.
year award category nominee result
2005 tony award best costume design william ivey long nominated

Step 5: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
year award category nominee result
2005 tony award best costume design william ivey long nominated

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE