Which roller coasters are longer than 3300?
select roller_coaster_id from roller_coaster where length > 3300
Among those longer than 3300
select roller_coaster_id from roller_coaster where length > 3300 and height > 100
And what are their status?
select roller_coaster_id, status from roller_coaster where length > 3300 and height > 100
Yes, what is their speed?
select roller_coaster_id, status, speed from roller_coaster where length > 3300 and height > 100