which amusement ride is in american waterfront?
(AND amusement_parks.ride (JOIN amusement_parks.ride.area m.0bh7h_g))