There are multiple ways to create the query in Question 9. Write the SQL command that you used and then write an alternate command that also would obtain the correct result.

SELECT Reservation. ReservationID, Customer. CustomerNum, Customer.FirstName, Customer.LastName

FROM Reservation, Customer

WHERE Customer.CustomerNum=Reservation.CustomerNum

AND Reservation.TripDate BETWEEN #7/1/2018# AND #7/31/2018#;