Table: flying_jumbos
Columns: ride_name
type
opened_in
themed_land
manufacture

Question: What is the latest year a ride opened that was manufactured by Zamperla, was a convoy ride, and had a name of Tiny Truckers?
SQL: SELECT MAX("opened_in") FROM flying_jumbos WHERE "manufacture" = 'zamperla' AND "type" = 'convoy ride' AND "ride_name" = 'tiny truckers'

Question: Who is the manufacturer of the mini jet red baron ride that opened before 2001?
SQL: SELECT "manufacture" FROM flying_jumbos WHERE "opened_in" < 2001 AND "type" = 'mini jet red baron'