Yes
select length from roller_coaster where park = "Kemah Boardwalk"
Find the status of Happy Valley.
select status from roller_coaster where park = "Happy Valley"
What are the country id of Hades 360?
select country_id from roller_coaster where name = "Hades 360"
What are the speeds of the longest roller coaster?
select speed from roller_coaster order by length desc limit 1