Groups

    MySQL Help!

    Hey There!

    Just wondering what the query would look like if I wanted to find the average number of nights stayed in one visit by any of the hotels in the group?

    The Table is like this:
    __________________________
    | Booking ID | Hotel Name | Guest ID | Date of Arrival | Date of departure |

    Hope you can help with this, been battling with it for over an hour!

    2 Comments

    vbforums.com/

    post here, post your coding there to, dont say its for cwk otherwise they won't do it.

    Original Poster

    black gerbil1;7660154

    http://www.vbforums.com/post here, post your coding there to, dont say … http://www.vbforums.com/post here, post your coding there to, dont say its for cwk otherwise they won't do it.



    Thanks :thumbsup:
    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. 75% off Sky TV for existing customers. Only works when you call the specifi…17826348
      2. Royal Mil track and trace77
      3. Meerkat Movies (2 for 1 Cinema Codes) | Official Trading Thread423814465
      4. miikeyblue and shabbird's (but mostly shabbird's) Tuesday night pub quiz!553766

      See more discussions