Table: boardwalk_bullet
Columns: name
park
length_ft
height_ft
speed_mph
opened
status

Question: How many parks are called mt. olympus
SQL: SELECT COUNT("name") FROM boardwalk_bullet WHERE "park" = 'Mt. Olympus'

Question: How fast is the coaster that is 163 feet tall
SQL: SELECT "speed_mph" FROM boardwalk_bullet WHERE "height_ft" = 163

Question: What is the length of the coaster with the unknown speed
SQL: SELECT "length_ft" FROM boardwalk_bullet WHERE "speed_mph" = 'unknown'

Question: How long is the rollar coaster on Kemah Boardwalk
SQL: SELECT "length_ft" FROM boardwalk_bullet WHERE "park" = 'Kemah Boardwalk'

Question: What park is Boardwalk Bullet located in?
SQL: SELECT "park" FROM boardwalk_bullet WHERE "name" = 'Boardwalk Bullet'

Question: How many parks is Zippin Pippin located in
SQL: SELECT COUNT("park") FROM boardwalk_bullet WHERE "name" = 'Zippin Pippin'