begin %basic%

CREATE_VIEW Query8

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

FROM location_Info, HiredVendors as HV

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

end %basic%