3 Simple Queries SQL Student Question, Query Errors in Microsoft Access

1 vote

1 answer

371 views

query ms-access date ms-access-2016

                          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.

Asked by rubengavidia0x (135 rep)

Mar 15, 2021, 05:53 PM
Last activity: Apr 13, 2023, 10:04 AM

3 Simple Queries SQL Student Question, Query Errors in Microsoft Access

Related Questions