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) |