Step 1: Select rows where the 'model' is 'giant drop'.
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 the 'drop_height' is 200 feet.
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) |
Step 3: Select rows where the 'speed' is 62 mph.
park |
tower_height |
drop_height |
speed |
model |
opened |
height_requirement |
canada 's wonderland |
230feet |
200feet |
62 mph |
giant drop |
1997-01-01 |
inches (cm) |
Step 4: 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 |
canada 's wonderland |
230feet |
200feet |
62 mph |
giant drop |
1997-01-01 |
inches (cm) |