The First Question is: "List the name of each trip that does not start in New Hampshire (NH)."
SELECT TripName FROM Trip WHERE State!='NH'; /* works with State='NH' */
The Second Question is: "List the trip name, type, and maximum group size for all trips that have Susan Kiley as a guide."
SELECT TripName, MaxGrpSize FROM Trip, TripGuides WHERE Type=Hiking, GuideNum = 'BR01'; /* also i tried WHERE Type=Hiking AND GuideNum = 'BR01'; */
I Cant Filter by only type: "Hiking"
The Third Question is: List the reservation ID, customer number, customer last name, and customer first name for all trips that occur in July 2018. I Tried This:|
SELECT DISTINCT LastName, FirstName, CustomerNum, ReservationID FROM Customer, Reservation WHERE TripDate = '2018-12'; /* i tried CustomerNum.Customer */
If you need more tables and more information let me know.