Table: black_buccaneer
Columns: ride_name
type
opened_in
themed_land
manufacturer

Question: What type ride is Wild Asia that opened in 2000?
SQL: SELECT "type" FROM black_buccaneer WHERE "themed_land" = 'wild asia' AND "opened_in" = 2000

Question: What type of ride is Rameses Revenge?
SQL: SELECT "type" FROM black_buccaneer WHERE "ride_name" = 'rameses revenge'

Question: Which ride opened after the 2000 Peeking Heights?
SQL: SELECT "type" FROM black_buccaneer WHERE "opened_in" > 2000 AND "ride_name" = 'peeking heights'

Question: What ride was manufactured by Zierer?
SQL: SELECT "ride_name" FROM black_buccaneer WHERE "manufacturer" = 'zierer'