Which of them are higher than 100? | Do you mean among all roller costers or among the those longer than 3300? | Among those longer than 3300
SELECT Roller_Coaster_ID FROM roller_coaster WHERE LENGTH  >  3300 and Height > 100
higher than 100 refers to Height > 100; among those longer than 3300 refers to LENGTH > 3300;