SELECT CarId, Make, Model, ReturnLocation
FROM Agreement, Vehicle
WHERE '2018-01-04' BETWEEN HireStartDate AND HireEndDate
OR '2018-04-09' BETWEEN HireStartDate AND HireEndDate
AND Agreement.CarId = Vehicle.Id;