Plan-of-SQLs (Ours)

Statement: kings island 's attraction opened in 1999

Ground-truth: TRUE

Input Table: drop tower : scream zone

Step 1: Select rows where 'park' is 'kings island'.
park tower_height drop_height speed model opened height_requirement
canada 's wonderland 230feet 200feet 62 mph giant drop 1997-01-01 inches (cm)
carowinds 174feet 100feet 56 mph giant drop 1996-03-01 inches (cm)
california 's great america 224feet 207feet 62 mph giant drop 1996-03-01 inches (cm)
kings dominion 305feet 272feet 72 mph gyro drop 2003-03-22 inches (cm)
kings island 315feet 264feet 67 mph gyro drop 1999-01-01 inches (cm)
Step 2: Select rows where 'opened' is '1999-01-01'.
park tower_height drop_height speed model opened height_requirement
kings island 315feet 264feet 67 mph gyro drop 1999-01-01 inches (cm)
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
park tower_height drop_height speed model opened height_requirement
kings island 315feet 264feet 67 mph gyro drop 1999-01-01 inches (cm)
Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE