Yes, what is their speed?
SELECT Roller_Coaster_ID , status, Speed FROM roller_coaster WHERE LENGTH  >  3300 and Height > 100
their speed refers to Speed; condition mentioned refers to LENGTH > 3300 AND Height > 100;