begin %basic%

CREATE_VIEW Query9

SELECT HV.eventDate, HV.startTime, HV.endTime, location_Info.name

FROM location_Info, HiredVendors as HV

WHERE HV.name = "Giggles_the_Clown", HV.locationID = location_Info.id

end %basic%