human
Schema:
roller_coaster (Roller_Coaster_ID, Name, Park, Country_ID, Length, Height, Speed, Opened, Status)
country (Country_ID, Name, Population, Area, Languages)
Please answer with SQL.
assistant
Sure, I understand.
human
what is the highest length of coaster
assistant
SELECT MAX( Length ) FROM roller_coaster;
human
which roller coaster are top speed
assistant
SELECT * FROM roller_coaster ORDER by Speed desc LIMIT 1;
human
what is the height of Boardwalk Bullet
assistant
SELECT Height FROM roller_coaster WHERE Name = "Boardwalk Bullet" ;