MySQL Help! - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

MySQL Help!

SAVE4IT Avatar
6y, 10m agoPosted 6 years, 10 months ago
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!
SAVE4IT Avatar
6y, 10m agoPosted 6 years, 10 months ago
Options

All Comments

(2) Jump to unreadPost a comment
Comments/page:
#1
http://www.vbforums.com/

post here, post your coding there to, dont say its for cwk otherwise they won't do it.
#2
black gerbil1
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

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!