Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2013
    Posts
    5

    Post Unanswered: keep getting aggregate function error

    List the guests by name and the number of times each has reserved a room at one of our hotels. Arrange the list in order from most-frequent to least-frequent guest.

    so far i have this code set up

    Code:
    SELECT FirstName, LastName, Count(ResNum) AS TotalReservations
    FROM RESERVATION, GUEST
    Where GUEST.GuestNo = RESERVATION.GuestNo
    ORDER BY RESERVATION.GuestNo

    I'm keep getting aggregate function for FirstName


    Here is the Table link

    view Table

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    view earlier attempt at posting this question
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •