on 2006-09-30, which amusement ride was closed?
(AND amusement_parks.ride (JOIN amusement_parks.ride.closed 2006-09-30^^http://www.w3.org/2001/XMLSchema#date))